{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Instructions","Budget and Setup","Pay Pool Panel","Bonus Adjustment Summary","Pay Bands","Hidden Config","Summary","Rating Statistics","Rating Charts","Hidden Sal Inc Rates","Salary Increase Statistics","Hidden Combo Chart","Salary Increase Charts","Total Salary Increase Charts","Bonus Statistics","Bonus Charts","OpenSheet","Hidden Work","Hidden Employee Notices","Hidden Employee Bonus Notices"],"not_rendered":{"charts":25,"images":28,"macros":1,"external_links":0,"defined_names":542,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,2,1,11],[3,4,3,10],[2,4,2,10],[19,2,19,11],[15,2,15,11],[16,2,16,11],[18,2,18,11],[6,2,6,11],[4,2,4,11],[8,3,8,11],[14,3,14,11],[7,3,7,11],[11,3,11,11],[9,3,9,11],[10,3,10,11],[13,5,13,11]]}
[]
[null,null,"DCIPS Compensation Workbench (CWB)"]
[null,null,null,null,2024]
[null,null,null,null,"For Official Use Only\nInformation protected by the Privacy Act of 1974"]
[null,null,"This application will help DCIPS organizations conduct the DCIPS pay pool process."]
[]
[null,null,"How to use this spreadsheet:"]
[null,null,"Step 1:","            your pay pool’s data into the spreadsheet.  Remember that your data file must be in the same folder as the spreadsheet.  The spreadsheet will then import your data and display a confirmation message when complete."]
[null,null,"Step 2:","Administrator Only: Enter the pay pool's budget parameters, bonus increment, and administrator options on the Pay Pool Budget and Setup worksheet.  To lock the worksheet, select the lock setup button and enter a password that you will remember.  To unlock the worksheet, select the unlock setup button and enter your password.\n"]
[null,null,"Step 3:","NGA Only: Reconcile base pay increase amounts in the Pay Pool Panel worksheet.  Enter justification for any adjustments if required."]
[null,null,"Step 4:","Determine a rating threshold for bonuses.  This threshold rating receives 1 bonus share.  Decimal rating increments between the threshold and a rating of 5 will receive increasing bonus amounts."]
[null,null,"Step 5:","Review data and charts on the statistics worksheets to ensure the pay pool results are fair and consistent."]
[null,null,"Step 6:",null,null,null,null,"Not Certified"]
[null,null,"Step 7:"]
[null,null,"Step 8:","                                              once the results have been approved by the PRA.  Employee notices will be generated in the order in which they appear in the Pay Pool Panel worksheet.  If filters have been set, notices will only be generated for visible Employees."]
[null,null,"Notes and Special Features:"]
[null,null,"A number of features are accessed through buttons on the custom tool bar.  These include Import, Export, and features such as Hide and Sort.  The Validate feature is critical to the correct use of the spreadsheet.   When the Validate button is clicked on any of the worksheets where it appears, spreadsheet errors will be circled in red on the Pay Pool Panel worksheet for easy identification and attention.\nRight-clicking the left and right arrows in the bottom left of the the Excel application window will allow fast switching to any sheet in the CWB."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,false]
[]
[null,{"$f":"OFFSET(aPPM,1,0)","v":0}]
[]
[null,{"$f":"OFFSET(aPRA,1,0)","v":0}]
[]
[null,{"$f":"LEFT(Export_44,4)","v":"2024"}]
[null,{"$f":"IF(LEN(OFFSET(aPPID,1,0))=0,\"\",OFFSET(aPPID,1,0))","v":""}]

{"sheet":"Budget and Setup","index":1,"n_rows":87,"n_cols":11,"rows_kept":87,"cut":false,"hidden":false,"merged":[[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[79,2,80,4],[5,3,5,4],[56,2,58,7],[70,2,71,4],[76,2,77,4],[73,2,73,4]]}
[null,"Pay Pool Population and Salary Information",null,null,null,null,null,null,null,null,"Go to:"]
[null,null,null,"Population",null,null,"Sum of Base Salary",null,"Sum of Adjusted Salary"]
[null,null,"Entire PayPool",{"$f":"EmpCount","v":0},null,null,{"$f":"SUM(BasePay)","v":0},null,{"$f":"SUM(AdjSalary)","v":0}]
[null,null,"Rated",{"$f":"COUNTIF(Rating,\">0\")","v":0},null,null,{"$f":"SUMIF(Rating,\">0\",BasePay)","v":0},null,{"$f":"SUMIF(Rating,\">0\",AdjSalary)","v":0}]
[null,null,"Rated and Included in Salary Calculation",{"$f":"SUM((Rating>0)*(IncInSalFund=\"Yes\")*1)","v":0},null,null,{"$f":"SUM((Rating>0)*(IncInSalFund=\"Yes\")*BasePay)","v":0},null,{"$f":"SUM((Rating>0)*(IncInSalFund=\"Yes\")*AdjSalary)","v":0}]
[null,null,"Rated and Included in Bonus Calculation",{"$f":"SUM((Rating>0)*(IncInBonFunds=\"Yes\")*1)","v":0},null,null,{"$f":"SUM((Rating>0)*(IncInBonFunds=\"Yes\")*BasePay)","v":0},null,{"$f":"SUM((Rating>0)*(IncInBonFunds=\"Yes\")*AdjSalary)","v":0}]
[]
[]
[null,"Pay Pool Salary Increase Budget"]
[]
[null,null,null,null,"%",null,"$"]
[]
[null,null,"Salary Increase Funding",null,2.3E-2,null,{"$f":"ROUND(SumBasePayElig*E13,0)","v":0}]
[]
[null,null,"- Organization Withhold/Reserve (optional)",null,0,null,{"$f":"IF(EmpCount=0,0,ROUND(SalResvPercent*SalIncFunding,0))","v":0}]
[]
[null,null,"+ Additional Salary Increase Funding (optional)",null,0,null,{"$f":"ROUND(SalIncFunding*SalIncPercent,0)","v":0}]
[]
[null,null,"Total Salary Increase Budget",null,{"$f":"IF(SumBasePayElig=0,0,G19/G5)","v":0},null,{"$f":"G13-G15+G17","v":0}]
[]
[null,null," - Adjustment Funding (optional)",null,0,null,{"$f":"ROUND(SalInterimBudget*SalSetAsidePercent,0)","v":0}]
[]
[null,null,"Salary Increase Funding Available to Algorithm",null,{"$f":"IF(SumBasePayElig=0,0,SalFund/SumBasePayElig)","v":0},null,{"$f":"G19-G21","v":0}]
[]
[]
[null,"Pay Pool Bonus Budget"]
[null,null,null,null,"Adjusted"]
[null,null,"Use Base Salary or Adjusted Basic Pay?",null,"Base Salary",null,"Adjusted Basic Pay"]
[]
[null,null,null,null,"%",null,"%",null,"$"]
[null,null,null,null,0.01,null,2.5000000000000001E-2]
[null,null,"Bonus Budget Percentage",null,{"$f":"IF(EmpCount=0,0,ROUND(BonFund/SumBonusElig,6))","v":0},null,2.5000000000000001E-2,null,{"$f":"ROUND(SumBonusElig_Adj*G32,0)","v":0}]
[]
[null,null,"- Organization Withhold/Reserve (optional)",null,{"$f":"IF(EmpCount=0,0,ROUND(BonResvDollar/BonFund,6))","v":0},null,0,null,{"$f":"IF(EmpCount=0,0,ROUND(BonResvPercent_Adj*BonFund,0))","v":0}]
[]
[null,null,"+ Additional Bonus Funding (optional)",null,{"$f":"IF(EmpCount=0,0,ROUND(BonFundDollar/BonFund,6))","v":0},null,0,null,{"$f":"IF(EmpCount=0,0,ROUND(BonFundPercent_Adj*BonFund,0))","v":0}]
[]
[null,null,"Total Bonus Budget",null,{"$f":"IF(SumBonusElig=0,0,I38/SumBonusElig)","v":0},null,{"$f":"IF(SumBonusElig_Adj=0,0,I38/SumBonusElig_Adj)","v":0},null,{"$f":"I32-I34+I36","v":0}]
[]
[null,null," - Adjustment Funding (optional)",null,{"$f":"IF(EmpCount=0,0,ROUND(BonSetAsideDollar/BonInterimBudget,6))","v":0},null,0,null,{"$f":"IF(EmpCount=0,0,ROUND(BonSetAsidePercent_Adj*BonInterimBudget,0))","v":0}]
[]
[null,null,"Bonus Funding Available to Algorithm",null,{"$f":"IF(SumBonusElig=0,0,bonusfund/SumBonusElig)","v":0},null,{"$f":"IF(SumBonusElig_Adj=0,0,bonusfund/SumBonusElig_Adj)","v":0},null,{"$f":"I38-I40","v":0}]
[]
[]
[]
[null,"DCIPS Quality Increase / Sustained Quality Increase Budget"]
[]
[null,null,"Budget for DQI/SQI (Set by DCIPS Guidance)",null,null,null,1.6999999999999999E-3,null,{"$f":"ROUND(Export_43*G48,0)","v":0}]
[]
[]
[null,"Bonus Setup"]
[]
[null,null,"Maximum Bonus",25000]
[]
[null,null,"Share Increment",0.1]
[]
[null,null,"What is the share increment?\nThe DCIPS bonus algorithm gives the employee receiving the threshold rating 1 bonus share.  Then each tenth of a rating higer receives X% more shares than the previous rating, where X = the share increment."]
[]
[]
[]
[]
[]
[null,"Floor Increase"]
[]
[null,null,{"$f":"CONCATENATE(1+LEFT(Export_44,4),\" Salary Increase Floor (Set by DoD)   =\")","v":"2025 Salary Increase Floor (Set by DoD)   ="},{"$f":"GPI","v":0.01}]
[]
[]
[null,null,null,"Band"]
[null,"Administrator Options",null,2]
[]
[null,null,"Allow edits to budget and payout eligiblity in the Pay Pool Panel worksheet (columns G, H, I, and J)?",null,null,null,"Yes"]
[]
[]
[null,null,"Allow edits to the JDA column in the Pay Pool Panel worksheet (column N)?",null,null,null,"Yes"]
[]
[]
[null,null,"Allow edits to the Variable Control Points in the Pay Pool Panel worksheet (column BI)?",null,null,null,"Yes"]
[]
[]
[null,null,"Allow edits to the Rating Threshold in the Pay Pool Panel Worksheet\n(cell EA7)?",null,null,null,"Yes"]
[]
[]
[null,null,"Allow printing of Employee Notices?",null,null,null,"Yes"]
[]
[null,null,"Allow modifications to the Special Situated Condition value list?",null,null,"Yes","Yes"]
[]
[null,null,"Allow modifications to the Bonus Adjustment Justification value list?",null,null,"Yes","Yes"]

{"sheet":"Pay Pool Panel","index":2,"n_rows":31,"n_cols":165,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,158,3,167]]}
["Go To:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salary Increase Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impact of Decisions",null,null,null,null,null,"Bonus Budget"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ratings",null,null,null,null,null,null,null,"Salary",null,null,null,null,null,null,null,null,null,"Total Shares",{"$f":"SUM(PristineInterimShares)","v":0},null,null,null,null,"Total Shares",{"$f":"SUM(PristineFinalShares)","v":0},null,null,null,null,{"$f":"SUM(ProShares)","v":0},null,null,null,null,null,null,null,"Total Shares",{"$f":"SUM(FinalShares)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Salary Increase Fund",{"$f":"SalInterimBudget","v":0},{"$f":"SalInterimBudPct","v":0},"% of Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus",null,null,null,null,"Employees Eligible for Bonus",{"$f":"SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*1)","v":0},null,null,null,null,null,"Total Bonus Funding",{"$f":"BonInterimBudget","v":0},"% of Budget"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incr",null,null,null,null,null,null,null,null,null,"Interim SV",{"$f":"IF($BM$2>0,SalInterimBudget/BM2,0)","v":0},null,null,null,null,"Final SV",{"$f":"IF($BS$2>0,(SalInterimBudget-SUM(BQ12:BQ13))/BS2,0)","v":0},null,null,null,null,{"$f":"IF($BX$2>0,SalFund/BX2,0)","v":0},null,null,null,null,null,null,null,"Final SV",{"$f":"IF($CG$2>0,(SalFund-SUM(CE12:CE13)+IF(SalAdjust<0,-SalAdjust,IF(SalAdjPot<0,SalAdjPot,0)))/CG2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Funds Allocated via Algorithm",{"$f":"SUM(CH12:CH13)","v":0},{"$f":"IF(CV2=0,0,(CV3/CV2)*CW2)","v":0},{"$f":"IF($CW$2=0,0,$CW$3/$CW$2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employees Receiving Bonus",{"$f":"COUNTIF(TotalBonus,\">0\")","v":0},{"$f":"IF(SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*1)=0,0,$EA$3/SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*1))","v":0},null,null,null,null,"Allocated Via Algorithm",{"$f":"SUM(InitialBonus)","v":0},{"$f":"IF(EH$2=0,0,EH3/EH$2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Funds Allocated via Adjustment",{"$f":"SUM(CK12:CK13)","v":0},{"$f":"IF(CV2=0,0,(CV4/CV2)*CW2)","v":0},{"$f":"IF($CW$2=0,0,CW4/CW2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min Bonus",{"$f":"IF(COUNTIF(TotalBonus,\">0\")=0,0,LARGE(TotalBonus,COUNTIF(TotalBonus,\">0\")))","v":0},{"$f":"IF(COUNTIF(TotalBonusPer,\">0\")=0,0,LARGE(TotalBonusPer,COUNTIF(TotalBonusPer,\">0\")))","v":0},"of band midpoint",null,null,null,"Allocated Via Adjustment",{"$f":"EF10","v":0},{"$f":"IF(EH$2=0,0,EH4/EH$2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Funds Allocated",{"$f":"SUM(CV3:CV4)","v":0},{"$f":"IF(CV2=0,0,(CV5/CV2)*CW2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BonusMaximum","v":25000},null,null,null,null,"Max Bonus",{"$f":"MAX(TotalBonus)","v":0},{"$f":"MAX(TotalBonusPer)","v":0},"of band midpoint",null,null,null,"Total Funds Allocated",{"$f":"SUM(EH3:EH4)","v":0},{"$f":"IF(EH$2=0,0,EH5/EH$2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Funds Remaining",{"$f":"CV2-CV5","v":0},{"$f":"CW2-CW5","v":0},{"$f":"1-SUM(CX3:CX4)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Funds Remaining",{"$f":"EH2-EH5","v":0},{"$f":"IF(EH$2=0,0,EH6/EH$2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"0,1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EX-IV Cap",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rating Threshold",3.5,null,{"$f":"MaxShares","v":0.1},"Share Increment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"0,2"]
["Employees:",{"$f":"COUNTA(EmployeeID)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EXIVCap","v":191900},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SQI/DQI Funds",{"$f":"QI_Budget","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"0,1,2"]
["Visible Employees:",{"$f":"SUBTOTAL(3,EmployeeID)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean","Mean","Mean","Mode",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Floor = \", TEXT(Floor_GPI_Funding,\"0.00%\"))","v":"Floor = 1.00%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Share Valve",null,null,null,null,null,null,null,null,null,null,null,null,null,"Adj Funding","Total Adjustments","Remaining Adjustment Funding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum of Increases:",{"$f":"SUM(DD12:DD13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Share Value",null,"Adj Funding","Total Adjustments","Remaining Adjustment Funding",null,null,null,null,"Remaining",{"$f":"QI_Budget-SUM(EM12:EM13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(EmpCount=0,\"\",AVERAGE(IF(Rating>0,AU12:AU13)))","v":""},{"$f":"IF(EmpCount=0,\"\",AVERAGE(IF(Rating>0,AV12:AV13)))","v":""},{"$f":"IF(EmpCount=0,\"\",AVERAGE(IF(Rating>0,AW12:AW13)))","v":""},{"$f":"IF(ISNA(MODE(Rating)),\"\",MODE(Rating))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(SumBonusElig=0,'Hidden Sal Inc Rates'!G4=0),0,MAX(0,(BonInterimBudget)/SUMPRODUCT(BandMidpoints,PristineBonusSharesFinal))\n)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Export_07","v":0},{"$f":"SUM(SalIncAdj)","v":0},{"$f":"IF(SalAdjust<=0,CJ10,CJ10-CK10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Developmental/Promotion/TSA Increases",null,null,null,null,null,null,null,null,{"$f":"LEFT('Pay Bands'!D128,SEARCH(\" \",'Pay Bands'!D128,1)-1)","v":"2025"},{"$f":"LEFT('Pay Bands'!D128,SEARCH(\" \",'Pay Bands'!D128,1)-1)","v":"2025"},{"$f":"LEFT('Pay Bands'!D128,SEARCH(\" \",'Pay Bands'!D128,1)-1)","v":"2025"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BonusShareValue","v":0},null,{"$f":"BonSetAsideDollar","v":0},{"$f":"SUM(BonAdj)","v":0},{"$f":"IF(BonAdjust<=0,EE10,EE10-EF10)","v":0}]
["Last Name","First Name","Employee ID","Evaluation ID","Pay Pool ID","Specially Situated Condition","Include in Salary Incr. Fund Calcs?","Include in Bonus Fund Calcs?","Salary Incr. Eligible?","Bonus\nEligible?","Org ID 1","Org ID 2","Agency Group","JDA Status","Rating Cycle End Date","Last Incr. Date","Date WGI Due","Employee On Board Date (EOD)","Band Entry Date","Retained\nPay","Pay Plan (end of Evaluation Period)","Pay Band (end of Evaluation Period)","Base Salary (end of Evaluation Period)","LMS or TMS (end of Evaluation Period)","Total Basic (end of Evaluation Period)","Pay Plan (as of Extract Date)","Pay Band (as of Extract date)","Step (as of Extract Date)","Base Salary (as of Extract date)","% Incr. (column AC versus W)","Work Category","Occ Series","Position/Work Role Title","Work Level","Work Location","Geolocation Code","Locality Code","Locality Rate","Work Schedule","Employee Status","Rating Official","Reviewing Official","Pay Pool Manager","Performance Review Authority","Wildcard 1",null,"Objective Rating","Element Rating","Overall Rating","Evaluation of Record","Rating Description","Wildcard 2","Wildcard 3",null,"Base Salary (end of Evaluation Period)","End Cycle % in Band","Salary Incr. Floor ($)","Base Pay + Salary Incr. Floor","Initial Base Pay Incr. Rate","Midpoint","Variable Control Point","Used Midpoint","End Cycle Compa Ratio","Multiplier","Preliminary Interim Base Pay Increase Shares","Preliminary Interim Base Pay Increase","Preliminary Interim New Base Pay (computed)","Preliminary Hit Max for Band?","Preliminary Interim Base Pay Incr To Meet Max","Preliminary Interim Base Pay Increase above Max","Preliminary Final Base Pay Increase Shares","Preliminary Initial Performance Salary Incr $","Preliminary Adjusted New Base Salary (computed)","Preliminary Bonus Shares","Preliminary Total Bonus \n($)","Interim Base Pay Incr. Shares","Salary Shares Proration (%)","Shares w/ Proration","Interim Base Pay Incr.","Interim New Base Pay (computed)","Pay Band Max","Hit Max for Band?","Interim Base Pay Incr. To Meet Max","Interim Base Pay Incr. above Max","Final Base Pay Incr. Shares","Initial Perf. Salary Incr.\n($)","Initial Perf. Salary Incr.\n(%)","Override Initial Incr.","Perf. Salary Incr. Adjustment","Perf. Salary Adjustment Justification","Wildcard 4","Wildcard 5","Max Salary Incr.","Base Salary (as of Extract date)","Salary Incr. Floor","Adjusted New Base Salary (computed)","New Pay Band Max","Hit New Band Max?","Floor Salary Incr.\n($)","Floor Salary Incr.\n(%)","Perf. Salary Incr.\n($)","Perf. Salary Incr.\n(%)","Total Salary Incr. ($)\n(Includes Floor)","Total Salary Incr. (%)\n(Includes Floor)","New Base Salary",{"$f":"CONCATENATE(1+LEFT(Export_44,4),\" % in Band\")","v":"2025 % in Band"},"Type of Incr.","Amount\nof Other\nIncr.\n($)","New Pay Band","Pay Pool Notes\n(notes will NOT print on feedback form)","Wildcard 6","Wildcard 7","Pay Band Minimum","Pay Band Maximum","New Increased Pay","LMS Rate","LMS Amount","Salary + LMS","Filler 1","Filler 2","Filler 3","Wildcard 8","Wildcard 9","Wildcard 10",null,"Awards Received This Rating Period","Total $ of Awards Received","Date of last QSI or Equiv","$ Amount of last QSI or Equiv","Overall Rating","Bonus Shares","Bonus Share Proration (%)","Bonus Shares","Initial Bonus ($)","Override Initial Bonus","Bonus Adjustment \n($)","Bonus\nAdjustment Justification","Total Bonus\n($)","Total Bonus (% of Midpoint)","Total Bonus (% of Base Salary)","SQI Eligible?","Number of Steps to Award","Estimated  $ Amount of Award","Wildcard 11","Wildcard 12","Wildcard 13","Wildcard 14","Pay Pool Panel Working Notes\n(these notes are for pay pool panel use only)","Remarks for Employee Feedback Form\n(these remarks will print on the employee's feedback form generated by the CWB)","Extract Date","Region Code","At Appraisal Lookup","At Appraisal Max","At Extract Lookup","At Extract Max uses Other Inc if entered","For QSI lookup","QSI Increment","QSI Category","Band for New Year","Use in Salary Analysis","For Stats","Work Cat/Level","Perm Hidden","Keep this Blank"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(LEN($A13)=0,$W13=\"\"),\"\",IF($AC13<>W13,($AC13-$W13)/$W13,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN($A13)=0,\"\",IF(AX13=3,\"Successful\",IF(AX13=4,\"Excellent\",IF(AX13=5,\"Outstanding\",IF(AX13=2,\"Min Successful\",IF(AX13=1,\"Unacceptable\",\"No Rating\"))))))","v":""},null,null,null,null,{"$f":"IF(OR(LEN($A13)=0,NOT(isNGAMode)),\"\",IF($CC13=0,0,($BC13-VLOOKUP($EV13,CurrentPayBands,2,FALSE))/(VLOOKUP($EV13,CurrentPayBands,4,FALSE)-VLOOKUP($EV13,CurrentPayBands,2,FALSE))))","v":""},{"$f":"IF(OR(ISBLANK($A13),NOT(isNGAMode)),\"\",IF(BC13>CC13,0,CEILING(IF(AX13=1,0,1)*MIN($CC13-$BC13,Floor_GPI_Funding*$BC13),1)))","v":""},{"$f":"IF(OR(ISBLANK($A13),NOT(isNGAMode)),\"\",$BC13+$BE13)","v":""},{"$f":"IF(OR(LEN($A13)=0,NOT(isNGAMode)),\"\",IF(AX13<3,0,IF($T13=\"Yes\",0, IF($I13=\"Yes\",PayoutIncrement+PayoutIncrement*(AW13-LowRating)/RatingIncr,0))))","v":""},{"$f":"IF(LEN($EV13)=0,\"\",VLOOKUP($EV13,Control_Points_Current,3,FALSE))","v":""},null,{"$f":"IF(LEN($A13)=0,\"\",IF($BI13>0,$BI13,$BH13))","v":""},{"$f":"IF(OR(LEN($A13)=0,$BC13=\"\", $BJ13=\"\"),0,$BC13/$BJ13)","v":0},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0,$BK13=0),\"\",$BG13/$BK13)","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($I13=\"Yes\",($BJ13*BL13)/1000,0))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($I13=\"Yes\",TRUNC($BM13*PristineSalaryShareValue,0),0))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($I13=\"Yes\",BF13+BN13,BC13))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($BO13<=($CC13-1),\"No\",\"Yes\"))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF(AX13>0,IF(BP13=\"Yes\", MAX(CC13-BF13,0),0),0))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF(AX13>0,IF($BP13=\"Yes\", BO13-CC13,0),0))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($I13=\"Yes\",IF(BR13=0,BM13,0),0))","v":""},{"$f":"IF(PristineFinalCalcShareValue<0,0,IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF(I13=\"Yes\",IF(BQ13=0,TRUNC(BS13*PristineFinalCalcShareValue,0),BQ13),0)))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",CP13+CQ13+BT13)","v":""},{"$f":"IF(LEN($A13)=0,\"\",IF(J13=\"Yes\",IF(DZ13>=BonusThreshold,VLOOKUP(DZ13,BonusShareLookup,2,FALSE),\"\"),\"\"))","v":""},{"$f":"IF(LEN($A13)=0,\"\",IFERROR(TRUNC(BH13*BV13*PristineBonusShareValue,0),0))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($I13=\"Yes\",IF(CJ13=\"Yes\",0,IF(OR($BJ13=\"\",$BL13=\"\"),0,($BJ13*BL13)/1000)),0))","v":""},null,{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($BY13<>\"\",$BX13*$BY13,BX13))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($I13=\"Yes\",TRUNC($BZ13*SalaryShareValue,0),0))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($I13=\"Yes\",BF13+CA13,BC13))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",$EW13)","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($T13=\"Yes\",\"No\",IF($CB13<=($CC13-1),\"No\",\"Yes\")))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF(AX13>0,IF(CD13=\"Yes\", MAX(CC13-BF13,0),0),0))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF(AX13>0,IF(AND($CD13=\"Yes\",T13<>\"Yes\"), CB13-CC13,0),0))","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF($I13=\"Yes\",IF(CF13=0,BZ13,0),0))","v":""},{"$f":"IF(FinalCalcShareValue<0,0,IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",IF(I13=\"Yes\",IF(CE13=0,TRUNC(CG13*FinalCalcShareValue,0),CE13),0)))","v":""},{"$f":"IF(OR(LEN($A13)=0,$BC13=\"\",NOT(isNGAMode)),\"\",$CH13/$BC13)","v":""},null,null,null,null,null,{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),\"\",MAX(0,CC13-BF13))","v":""},null,{"$f":"IF(OR(NOT(isNGAMode),ISBLANK($Y13)),0,IF(CP13>CS13,0,CEILING(MIN($CS13-$CP13,Floor_GPI_Funding*$CP13),1)))","v":0},{"$f":"IF(OR(NOT(isNGAMode),LEN($Y13)=0),\"\",CP13+CQ13+CH13+CK13)","v":""},{"$f":"IF(LEN($Y13)=0,\"\",$EY13)","v":""},{"$f":"IF(OR(NOT(isNGAMode),LEN($Y13)=0),\"\",IF($CR13<=($CS13),\"No\",IF($T13=\"Yes\",\"No\",\"Yes\")))","v":""},{"$f":"CQ13","v":0},{"$f":"IF(LEN($Y13)=0,0,CU13/CP13)","v":0},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0),0,IF(CT13=\"Yes\",(CS13-CP13),(CH13+CK13)))","v":0},{"$f":"IF(OR(NOT(isNGAMode),LEN($A13)=0,$BC13=\"\"),0,ROUND($CW13/$BC13,4))","v":0},{"$f":"IF(OR(NOT(isNGAMode),LEN($Y13))=0,0,CU13+CW13)","v":0},{"$f":"IF(OR(NOT(isNGAMode),LEN($Y13)=0),0,CY13/CP13)","v":0},{"$f":"IF(OR(NOT(isNGAMode),LEN($Y13)=0),0,CR13)","v":0},{"$f":"IF(OR(NOT(isNGAMode),LEN($Y13)=0),\"\",IF(CC13=0,0,(DK13-VLOOKUP(FC13,Control_Points_New,2,FALSE)))/(VLOOKUP(FC13,Control_Points_New,4,FALSE)-VLOOKUP(FC13,Control_Points_New,2,FALSE)))","v":""},null,null,null,null,null,null,{"$f":"IF(LEN($Y13)=0,\"\",VLOOKUP(FC13,Control_Points_New,2,FALSE))","v":""},{"$f":"IF(DE13=0,EY13,VLOOKUP(FC13,Control_Points_New,4,FALSE))","v":0},{"$f":"IF(isNGAMode,SUM(AC13,CU13,CW13,DD13),$DA13)","v":0},{"$f":"IF(AND(isNGAMode,$AX13=1),IF(ISNA(VLOOKUP($AK13,LocTable,3,FALSE)),0,VLOOKUP($AK13,LocTable,3,FALSE)),IF(ISNA(VLOOKUP($AK13,LocTable,4,FALSE)),0,VLOOKUP($AK13,LocTable,4,FALSE)))","v":0},{"$f":"MAX(0,$DN13-$DK13)","v":0},{"$f":"IF(LEN($Y13)=0,0,IF(UPPER($T13)=\"YES\",$DK13,MIN($DK$8,ROUND($DK13*(100+DL13)/100,0))))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN($A13)=0,\"\",$AW13)","v":""},{"$f":"IF(OR(LEN($A13)=0,$U13=\"GS\"),\"\",IF(J13=\"Yes\",IF(EE13=\"Yes\",\"\",IF(DZ13>=BonusThreshold,VLOOKUP(DZ13,BonusShareLookup,2,FALSE),\"\")),\"\"))","v":""},null,{"$f":"IF(OR(LEN($A13)=0,LEN($EA13)=0),\"\",IF($EB13<>\"\",$EB13*$EA13,EA13))","v":""},{"$f":"IF(LEN($EC13)=0,\"\",TRUNC(BH13*EC13*BonusShareValue,0))","v":""},null,null,null,{"$f":"SUM(EF13,ED13)","v":0},{"$f":"IF(OR(LEN($A13)=0,$BH13=\"\"),0,ROUND($EH13/$BH13,4))","v":0},{"$f":"IF(OR(LEN($H13)=0,$BC13=\"\"),0,ROUND($EH13/$BC13,4))","v":0},null,null,{"$f":"IF(LEN($A13)=0,\"\",EL13*FA13)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(LEN(U13)=0,\"\",IF(OR(isNGAMode,IFERROR(FIND(U13,\"IA.PI\"),0)>0),CONCATENATE(U13,V13),CONCATENATE(\"IA\",VLOOKUP(CONCATENATE(AE13,AH13),CatLevel,2,FALSE))))","v":""},{"$f":"IF($EV13=\"\",0,VLOOKUP($EV13,Control_Points_New,4,FALSE))","v":0},{"$f":"IF(isNGAMode,CONCATENATE(Z13,AA13),EV13)","v":""},{"$f":"IF(isNGAMode,IFERROR(VLOOKUP(EX13,Control_Points_New,4,FALSE),0),IFERROR(VLOOKUP(EZ13,Control_Points_New,4,FALSE),0))","v":0},{"$f":"CONCATENATE(Z13,AA13)","v":""},{"$f":"IF(isNGAMode,0,IF(LEFT(EZ13,2)=\"GS\",0,VLOOKUP(EZ13,Control_Points_New,5,FALSE)))","v":{"$error":"#N/A"}},{"$f":"IF(OR(isNGAMode,T13=\"Yes\",AW13<2.6,U13=\"GS\"),0,IF(SUM(AC13,2*FA13)<=EY13,3,IF(SUM(AC13,FA13)<=EY13,1,0)))","v":0},{"$f":"IF(LEN($C13)=0,\"\",IF($DE13=0,CONCATENATE($Z13,$AA13),CONCATENATE($Z13,$DE13)))","v":""},{"$f":"IF(T13=\"Yes\",0,IF(UPPER(I13)<>\"YES\",0,IF(AX13>=1,1,0)))","v":0},{"$f":"IF(OR(U13=\"\",ISERR(FIND(U13,\"GG.IA.PI.PP\",1))),\"\",CONCATENATE(U13,\"-\",TEXT(V13,\"00\")))","v":""},{"$f":"IF(ISBLANK($A13),\"\",CONCATENATE(IF(UPPER($AE13)=\"T\",\"Tech/Admin\",IF(UPPER($AE13)=\"P\",\"Prof\",IF(UPPER($AE13)=\"S\",\"Super/Mgmt\",\"Other\"))),\" - \",IF($AH13=1,\"Entry\",IF($AH13=2,\"Full Perf.\",IF($AH13=3,\"Senior\",IF($AH13=4,\"Expert\",$AH13))))))","v":""}]
[null,null,null,null,null,null,"X",null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","X",null,null,null,null,null,null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X",null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X",null,null,"X","X","X","X","X","X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","nonNGA_Hide"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","X","X",null,null,null,null,null,null,"X","X",null,null,null,null,null,null,null,null,null,null,null,"X","X","X",null,null,null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","NGA_Hide"]
[]
["Remove X in this row to hide columns",null,"X","X","X","X",null,"X",null,"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X",null,null,null,null,null,null,null,null,null,null,"X","X","X","X","X","X","X","X","X","X","X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","X","X","X","X","X","X"]
["Yes"]
["No"]
[]
[]
[{"$f":"SUM($AX12:$AX13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[]
[292,false]
[null,{"$f":"IF(isNGAMode,\"Pay Band\",\"Grade\")","v":"Grade"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]

{"sheet":"Bonus Adjustment Summary","index":3,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Last Name","First Name","Employee ID","Overall Rating","Bonus\nProrated?","Bonus Overridden?","Bonus\nAdjusted?","Bonus Adjustment Justification","Emp Rownum","Perm Hidden"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($A4),\"\",SUBSTITUTE(VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,MATCH(J$3,'Pay Pool Panel'!$C$11:$FH$11,0),FALSE),\"0\",\"\"))","v":""}]
[null,null,null,{"$f":"INDEX(AverageRating,I5,1)","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(BonShareProPct,I5,1)<>0,\"Yes\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(BonusOverride,I5,1)=\"Yes\",\"Yes\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(BonAdj,I5,1)=0,\"\",\"Yes\")","v":{"$error":"#N/A"}},{"$f":"IF(INDEX(BonAdjJust,I5,1)=0,\"\",INDEX(BonAdjJust,I5,1))","v":{"$error":"#N/A"}},{"$f":"MATCH(C5,EmployeeID,0)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK($A5),\"\",SUBSTITUTE(VLOOKUP($C5,'Pay Pool Panel'!$C$12:$FH$13,MATCH(J$3,'Pay Pool Panel'!$C$11:$FH$11,0),FALSE),\"0\",\"\"))","v":""}]

{"sheet":"Pay Bands","index":4,"n_rows":191,"n_cols":34,"rows_kept":191,"cut":false,"hidden":false,"merged":[[3,5,16,5],[0,1,0,4],[17,5,40,5],[32,30,32,31],[32,32,32,33],[11,32,11,33],[67,18,67,22],[45,30,45,31],[45,32,45,33],[0,6,0,9],[2,30,2,31],[11,30,11,31],[2,32,2,33],[68,18,69,18],[68,19,69,19],[68,20,69,20],[68,21,69,21],[68,22,69,22]]}
[null,{"$f":"CONCATENATE(Cycle,\" Pay Band Information\")","v":"2024 Pay Band Information"},null,null,null,null,{"$f":"CONCATENATE(Cycle+1,\" Pay Band Information\")","v":"2025 Pay Band Information"},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cycle+0,\"  version\")","v":"2024  version"},null,null,null,null,null,{"$f":"CONCATENATE(Cycle+1,\"  version\")","v":"2025  version"},null,null,null,"Max or ",null,"For IA and GG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grade",null,"OPM Base","Increment","Step12",null,"Grade",null,"Base","Increment","Step12",null,null,"Bands"]
[null,"Pay Band","Minimum","Midpoint","Maximum",null,"Pay Band","Minimum","Midpoint","Maximum","Increment","Min RR","GPI","New \nEXIVCap","Old\nEXIVCap",1,null,21986,null,null,null,1,null,{"$f":"ROUND(R3*(1+GPI),0)","v":22206},null,null,null,null,"PayTableGrade",null,{"$f":"Cycle+1","v":2025},null,{"$f":"Cycle+2","v":2026}]
[null,"IA1",21986,{"$f":"ROUND(SUM(C4,E4)/2,0)","v":39671},57355,"Banded Systems","IA1",22206,{"$f":"ROUND(SUM(H4,J4)/2,0)","v":40068},57929,null,{"$f":"GPI","v":0.01},0.01,191900,183500,2,null,24722,null,null,null,2,null,24969,null,null,null,"Pay Band","Min","Max","Minimum","Maximum"," Minimum "," Maximum "]
[null,"IA2",41966,59609,77252,null,"IA2",42386,60206,78026,null,null,null,null,null,3,null,26975,899,36864,null,3,null,27245,{"$f":"ROUND(X5/30,0)","v":908},{"$f":"X5+11*Y5","v":37233},null,1,1,7,{"$f":"VLOOKUP($AC5,OldGSTable,3)","v":21986},{"$f":"VLOOKUP($AD5,OldGSTable,5)","v":57355},{"$f":"VLOOKUP($AC5,NewGSTable,3)","v":22206},{"$f":"VLOOKUP($AD5,NewGSTable,5)","v":57929}]
[null,"IA3",62107,91544,120981,null,"IA3",62728,92457,122185,null,null,null,null,null,4,null,30280,{"$f":"ROUND(R6/30,0)","v":1009},41379,null,4,null,30583,{"$f":"ROUND(X6/30,0)","v":1019},{"$f":"X6+11*Y6","v":41792},null,2,7,10,{"$f":"VLOOKUP($AC6,OldGSTable,3)","v":41966},{"$f":"VLOOKUP($AD6,OldGSTable,5)","v":77252},{"$f":"VLOOKUP($AC6,NewGSTable,3)","v":42386},{"$f":"VLOOKUP($AD6,NewGSTable,5)","v":78026}]
[null,"IA4",88520,115741,142961,null,"IA4",89405,116899,144392,null,null,null,null,null,5,null,33878,1129,46297,null,5,null,34217,1141,46768,null,3,11,13,{"$f":"VLOOKUP($AC7,OldGSTable,3)","v":62107},{"$f":"VLOOKUP($AD7,OldGSTable,5)","v":120981},{"$f":"VLOOKUP($AC7,NewGSTable,3)","v":62728},{"$f":"VLOOKUP($AD7,NewGSTable,5)","v":122185}]
[null,"IA5",123041,145597,168152,null,"IA5",124271,147052,169833,null,null,null,null,null,6,null,37765,1259,51614,null,6,null,38143,1271,52124,null,4,13,14,{"$f":"VLOOKUP($AC8,OldGSTable,3)","v":88520},{"$f":"VLOOKUP($AD8,OldGSTable,5)","v":142961},{"$f":"VLOOKUP($AC8,NewGSTable,3)","v":89405},{"$f":"VLOOKUP($AD8,NewGSTable,5)","v":144392}]
[null,"PI1",{"$f":"AE35","v":40309},50384,{"$f":"AF35","v":60459},null,"PI1",40712,50891,{"$f":"AH35","v":61070},null,null,null,null,null,7,null,41966,1399,57355,null,7,null,42386,1413,57929,null,5,15,15,{"$f":"VLOOKUP($AC9,OldGSTable,3)","v":123041},{"$f":"VLOOKUP($AD9,OldGSTable,5)","v":168152},{"$f":"VLOOKUP($AC9,NewGSTable,3)","v":124271},{"$f":"VLOOKUP($AD9,NewGSTable,5)","v":169833}]
[null,"PI2",{"$f":"AE36","v":44461},{"$f":"ROUND(SUM(C10,E10)/2,0)","v":55576},{"$f":"AF36","v":66691},null,"PI2",44906,{"$f":"ROUND(SUM(H10,J10)/2,0)","v":56132},{"$f":"AH36","v":67357},null,null,null,null,null,8,null,46475,1549,63514,null,8,null,46940,1565,64155]
[null,"PI3",49041,61300,73559,null,"PI3",49531,61914,74296,null,null,null,null,null,9,null,51332,1711,70153,null,9,null,51845,1728,70853,null,null,"Grades"]
[null,"PI4",54092,67612,81132,null,"PI4",54633,68290,81946,null,null,null,null,null,10,null,56528,1884,77252,null,10,null,57093,1903,78026,null,null,"PayTableGrade",null,{"$f":"AE3","v":2025},null,{"$f":"AG3","v":2026}]
[null,"PI5",59663,74581,89498,null,"PI5",60260,75327,90394,null,null,null,null,null,11,null,62107,2070,84877,null,11,null,62728,2091,85729,null,"Pay Band","Min","Max","Minimum","Maximum"," Minimum "," Maximum "]
[null,"PI6",65809,82261,98712,null,"PI6",66467,83081,99695,null,null,null,null,null,12,null,74441,2481,101732,null,12,null,75185,2506,102751,null,1,1,1,{"$f":"VLOOKUP($AC14,OldGSTable,3)","v":21986},{"$f":"VLOOKUP($AD14,OldGSTable,5)","v":0},{"$f":"VLOOKUP($AC14,NewGSTable,3)","v":22206},{"$f":"VLOOKUP($AD14,NewGSTable,5)","v":0}]
[null,"PI7",72587,90735,108883,null,"PI7",73313,91643,109973,null,null,null,null,null,13,null,88520,{"$f":"ROUND(R15/30,0)","v":2951},120981,null,13,null,89405,{"$f":"ROUND(X15/30,0)","v":2980},122185,null,2,2,2,24722,0,24969,0]
[null,"PI8",88136,104295,120454,null,"PI8",89017,105336,121654,null,null,null,null,null,14,null,104604,{"$f":"ROUND(R16/30,0)","v":3487},142961,null,14,null,105650,{"$f":"ROUND(X16/30,0)","v":3522},144392,null,3,3,3,26975,36864,27245,37233]
[null,"PI9",103672,122680,141688,null,"PI9",104709,123904,143099,null,null,null,null,null,15,null,123041,{"$f":"ROUND(R17/30,0)","v":4101},168152,null,15,null,124271,{"$f":"ROUND(X17/30,0)","v":4142},169833,null,4,4,4,30280,41379,30583,41792]
[null,"GG1",21986,{"$f":"ROUND(SUM(C18,E18)/2,0)","v":25473},28960,"Graded Systems - eligible for the DQI/SQI so increment needed","GG1",22206,{"$f":"ROUND(SUM(H18,J18)/2,0)","v":25728},29250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,33878,46297,34217,46768]
[null,"GG2",24722,{"$f":"ROUND(SUM(C19,E19)/2,0)","v":28716},32710,null,"GG2",24969,29003,33037,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,6,37765,51614,38143,52124]
[null,"GG3",26975,31920,36864,null,"GG3",27245,32239,37233,{"$f":"Y5","v":908},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,7,41966,57355,42386,57929]
[null,"GG4",30280,35830,41379,null,"GG4",30583,36188,41792,1019,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,8,46475,63514,46940,64155]
[null,"GG5",33878,40088,46297,null,"GG5",34217,40493,46768,1141,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,9,{"$f":"VLOOKUP($AC22,OldGSTable,3)","v":51332},{"$f":"VLOOKUP($AD22,OldGSTable,5)","v":70153},{"$f":"VLOOKUP($AC22,NewGSTable,3)","v":51845},{"$f":"VLOOKUP($AD22,NewGSTable,5)","v":70853}]
[null,"GG6",37765,44690,51614,null,"GG6",38143,45134,52124,1271,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,10,56528,77252,57093,78026]
[null,"GG7",41966,49661,57355,null,"GG7",42386,50158,57929,1413,null,null,null,null,"For Police PP/PI",null,null,null,null,null,null,null,null,null,null,null,11,11,11,62107,84877,62728,85729]
[null,"GG8",46475,54995,63514,null,"GG8",46940,55548,64155,1565,null,null,null,null,{"$f":"CONCATENATE(Cycle,\"  version\")","v":"2024  version"},null,null,null,null,null,{"$f":"CONCATENATE(Cycle+1,\"  version\")","v":"2025  version"},null,null,null,"Max or ",null,12,12,12,74441,101732,75185,102751]
[null,"GG9",51332,60743,70153,null,"GG9",51845,61349,70853,1728,null,null,null,null,"Grade",null,"OPM Base","Increment","Step14",null,"Grade/Band",null,"Base","Increment","Step14",null,13,13,13,88520,120981,89405,122185]
[null,"GG10",56528,66890,77252,null,"GG10",57093,67560,78026,1903,null,null,null,null,1,null,40309,{"$f":"ROUND(R27/26,0)","v":1550},{"$f":"R27+13*S27","v":60459},{"$f":"CEILING(R27/26,1)","v":1551},1,null,{"$f":"ROUND(R27*(1+GPI),0)","v":40712},{"$f":"ROUND(X27/26,0)","v":1566},{"$f":"X27+13*Y27","v":61070},null,14,14,14,104604,142961,105650,144392]
[null,"GG11",62107,73492,84877,null,"GG11",62728,74229,85729,2091,null,null,null,null,2,null,44461,{"$f":"ROUND(R28/26,0)","v":1710},66691,{"$f":"CEILING(R28/26,1)","v":1711},2,null,44906,{"$f":"ROUND(X28/26,0)","v":1727},67357,null,15,15,15,123041,168152,124271,169833]
[null,"GG12",74441,88087,101732,null,"GG12",75185,88968,102751,2506,null,null,null,null,3,null,49041,1886,73559,1887,3,null,49531,1905,74296]
[null,"GG13",88520,104751,120981,null,"GG13",89405,105795,122185,2980,null,null,null,null,4,null,54092,2080,81132,2081,4,null,54633,2101,81946]
[null,"GG14",104604,123783,142961,null,"GG14",105650,125021,144392,3522,null,null,null,null,5,null,59663,2295,89498,2295,5,null,60260,2318,90394,null,"For PI and PP"]
[null,"GG15",123041,145597,168152,null,"GG15",124271,147052,169833,4142,null,null,null,null,6,null,65809,2531,98712,2532,6,null,66467,2556,99695,null,null,"Bands"]
[null,"PP1",{"$f":"AE35","v":40309},{"$f":"ROUND(SUM(C33,E33)/2,0)","v":50384},{"$f":"AF35","v":60459},null,"PP1",{"$f":"AG48","v":40712},50891,{"$f":"AH48","v":61070},{"$f":"Y27","v":1566},null,null,null,null,7,null,72587,2792,108883,2792,7,null,73313,2820,109973,null,null,"PayTableGrade",null,{"$f":"Cycle+1","v":2025},null,{"$f":"Cycle+2","v":2026}]
[null,"PP2",{"$f":"AE36","v":44461},{"$f":"ROUND(SUM(C34,E34)/2,0)","v":55576},{"$f":"AF36","v":66691},null,"PP2",{"$f":"AG49","v":44906},{"$f":"ROUND(SUM(H34,J34)/2,0)","v":56132},{"$f":"AH49","v":67357},{"$f":"Y28","v":1727},null,null,null,null,8,null,88136,{"$f":"ROUND(R34/30,0)","v":2938},{"$f":"R34+11*S34","v":120454},{"$f":"CEILING(R34/30,1)","v":2938},8,null,89017,{"$f":"ROUND(X34/30,0)","v":2967},{"$f":"X34+11*Y34","v":121654},null,"Pay Band","Min","Max","Minimum","Maximum"," Minimum "," Maximum "]
[null,"PP3",49041,61300,73559,null,"PP3",49531,61914,74296,1905,null,null,null,null,9,null,103672,{"$f":"ROUND(R35/30,0)","v":3456},{"$f":"R35+11*S35","v":141688},{"$f":"CEILING(R35/30,1)","v":3456},9,null,104709,{"$f":"ROUND(X35/30,0)","v":3490},{"$f":"X35+11*Y35","v":143099},null,1,1,1,{"$f":"VLOOKUP($AC35,OldPPTable,3)","v":40309},{"$f":"VLOOKUP($AD35,OldPPTable,5)","v":60459},{"$f":"VLOOKUP($AC35,NewPPTable,3)","v":40712},{"$f":"VLOOKUP($AD35,NewPPTable,5)","v":61070}]
[null,"PP4",54092,67612,81132,null,"PP4",54633,68290,81946,2101,null,null,null,null,null,null,null,null,"Yellow go to step 12 only and WGI is based on 30 increments not 26",null,null,null,null,null,null,null,2,2,2,44461,66691,44906,67357]
[null,"PP5",59663,74581,89498,null,"PP5",60260,75327,90394,2318,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,3,49041,73559,49531,74296]
[null,"PP6",65809,82261,98712,null,"PP6",66467,83081,99695,2556,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4,4,54092,81132,54633,81946]
[null,"PP7",72587,90735,108883,null,"PP7",73313,91643,109973,2820,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,59663,89498,60260,90394]
[null,"PP8",88136,104295,120454,null,"PP8",89017,105336,121654,2967,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,6,65809,98712,66467,99695]
[null,"PP9",103672,122680,141688,null,"PP9",104709,123904,143099,3490,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,7,72587,108883,73313,109973]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,8,88136,120454,89017,121654]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,9,103672,141688,104709,143099]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grades"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PayTableGrade",null,{"$f":"AE33","v":2025},null,{"$f":"AG33","v":2026}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay Band","Min","Max","Minimum","Maximum"," Minimum "," Maximum "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,{"$f":"VLOOKUP($AC48,OldPPTable,3)","v":40309},{"$f":"VLOOKUP($AD48,OldPPTable,5)","v":60459},{"$f":"VLOOKUP($AC48,NewPPTable,3)","v":40712},{"$f":"VLOOKUP($AD48,NewPPTable,5)","v":61070}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,44461,66691,44906,67357]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,3,49041,73559,49531,74296]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4,4,54092,81132,54633,81946]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,59663,89498,60260,90394]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,6,65809,98712,66467,99695]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,7,72587,108883,73313,109973]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,8,88136,120454,89017,121654]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,9,103672,141688,104709,143099]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1yr Back","2014-01-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2yr Back","2013-01-13"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lookup for the DQI/SQI columns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"amount of award","means they got this many steps","at this grade","If before this date","then eligible for this step"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cat/Level","IA Band"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T1",1,null,null,0,0,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T2",2,null,0,0,0,null,3,null,"No longer utilized"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T3",3,2014,735,1,3,{"$f":"INDEX(yrs,T73)","v":"2014-01-12"},{"$f":"IF(T73=1,2,1)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P1",2,2015,743,1,3,"2014-01-12",{"$f":"IF(T74=1,2,1)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2",3,2014,825,1,4,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P3",4,2015,834,1,4,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P4",5,2014,924,1,5,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S2",3,2015,933,1,5,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S3",4,2014,1029,1,6,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S4",5,2015,1040,1,6,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,1144,1,7,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,1155,1,7,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,1267,1,8,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,1280,1,8,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,1399,1,9,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,1413,1,9,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,1470,2,3,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,1486,2,3,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,1541,1,10,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,1556,1,10,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,1650,2,4,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,1668,2,4,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,1693,1,11,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,1710,1,11,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,1848,2,5,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,1866,2,5,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,2029,1,12,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,2050,1,12,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,2058,2,6,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,2080,2,6,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,2288,2,7,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,2310,2,7,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,2413,1,13,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,2437,1,13,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,2534,2,8,{"$f":"INDEX(yrs,T105)","v":"2013-01-13"},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,2560,2,8,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,2798,2,9,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,2826,2,9,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,2851,1,14,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,2880,1,14,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,3082,2,10,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,3112,2,10,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,3354,1,15,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,3386,2,11,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,3388,1,15,"2014-01-12",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,3420,2,11,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,4058,2,12,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,4100,2,12,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,4826,2,13,"2013-01-13",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,4874,2,13,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,5702,2,14,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,5760,2,14,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,6708,2,15,"2013-01-13",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,6776,2,15,"2013-01-13",1]
[]
["Local Market Supplement"]
["LMS Code","Short Name",{"$f":"CONCATENATE(Cycle, \" LMS Rates\")","v":"2024 LMS Rates"},{"$f":"CONCATENATE(Cycle+1, \" LMS Rates\")","v":"2025 LMS Rates"}]
[]
[]
["AK","Alaska",31.96,31.96]
["AL","Albany-Schneectady, NY",20.25,20.25]
["AQ","Albuquerque-Santa Fe-Las Vegas, NM",18.05,18.05]
["AT","Atlanta",23.45,23.45]
["AU","Austin-Round Rock, TX",19.989999999999998,19.989999999999998]
["BH","Birmingham-Hoover-Talladega, AL",17.91,17.91]
["BO","Boston",31.97,31.97]
["BU","Buffalo",21.99,21.99]
["BN","Burlington-South Burlington, VT",18.97,18.97]
["CT","Charlotte-Concord, NC-SC",19.260000000000002,19.260000000000002]
["CH","Chicago",30.41,30.41]
["CI","Cincinnati",21.69,21.69]
["CL","Cleveland",22.01,22.01]
["CS","Colorado Springs, CO",19.73,19.73]
["CO","Columbus",21.8,21.8]
["CC","Corpus Christi-Kingsville-Alice, TX",17.399999999999999,17.399999999999999]
["DA","Dallas",26.91,26.91]
["DV","Davenport-Moline, IA-IL",18.66,18.66]
["DG","Dayton",21.14,21.14]
["DM","Des Moines-Ames-West Des Moines, IA",17.68,17.68]
["DN","Denver",29.88,29.88]
["DT","Detroit",28.82,28.82]
["FN","Fresno-Madera-Hanford, CA",17.149999999999999,17.149999999999999]
["HB","Harrisburg-Lebanon, PA",19.100000000000001,19.100000000000001]
["HA","Hartford",31.62,31.62]
["HI","Hawaii",21.79,21.79]
["HO","Houston",34.72,34.72]
["HU","Huntsville",21.48,21.48]
["IN","Indianapolis",17.89,17.89]
["KC","Kansas City-Overland Park-Kansas City, MO-KS",18.649999999999999,18.649999999999999]
["LR","Laredo, TX",21.33,21.33]
["LV","Las Vegas-Henderson, NV-AZ",19.23,19.23]
["LA","Los Angeles",35.840000000000003,35.840000000000003]
["MI","Miami",24.42,24.42]
["ML","Milwaukee",22.15,22.15]
["MN","Minneapolis",27.15,27.15]
["NY","New York",37.24,37.24]
["OM","Omaha-Council Bluffs-Fremont, NE-IA",17.940000000000001,17.940000000000001]
["ON","Other Non-For",16.82,16.82]
["PB","Palm Bay-Melbourne, FL",17.600000000000001,17.600000000000001]
["PH","Philadelphia",28.55,28.55]
["PX","Phoenix",22.02,22.02]
["PI","Pittsburgh",20.78,20.78]
["PO","Portland",25.66,25.66]
["RA","Raleigh",21.9,21.9]
["RN","Reno-Fernley, NV",17.11,17.11]
["RI","Richmond",21.91,21.91]
["RT","Rochester-Batavia-Seneca Falls, NY",17.350000000000001,17.350000000000001]
["SA","Sacramento",29.16,29.16]
["SO","San Antonio-New Braunfels-Pearsall, TX",18.489999999999998,18.489999999999998]
["SD","San Diego",33.049999999999997,33.049999999999997]
["SJ","San Jose",45.41,45.41]
["ST","Seattle",30.81,30.81]
["SN","Spokane-Spokane Valley-Coeur d'Alene, WA-ID",17.18,17.18]
["SL","St.Louis MO_IL",19.63,19.63]
["TU","Tucson-Nogales, AZ",18.920000000000002,18.920000000000002]
["VA","Virginia Beach-Norfolk VA-NC",18.46,18.46]
["WA","Washington, DC",33.26,33.26]
["ZX","Rest of U.S.",16.82,16.82]
["ZY","FBI Outside DC",0,0]
["ZZ","Not in a Locality Pay Area",0,0]

{"sheet":"Hidden Config","index":5,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":true,"merged":[[0,11,0,12]]}
[null,null,null,null,null,null,"Begin Data Row","End Data Row","PPP Hide Personnel Data","PPP Hide Calc",null,"Control List for ManageListForm"]
[null,null,null,null,null,null,{"$f":"ROW(aLastName)","v":12},{"$f":"ROW(InsertHere)","v":13},{"$f":"COUNTA($I3:$I50)","v":7},{"$f":"COUNTA($J3:$J50)","v":3},null,"<select>","Blanks","Blanks","Yes"]
[null,null,null,null,null,null,null,null,"C:E","AX:BA",null,"Special Situated Condition","SpecialSC","SSC",{"$f":"SSCGate","v":"Yes"},"Tech/Admin - Entry"]
[null,null,null,null,null,null,null,null,"M:M","BE:BM",null,"Bonus Adjustment Justification","BAJList","BonAdjJust",{"$f":"BAJGate","v":"Yes"},"Tech/Admin - Full Perf."]
[null,null,null,null,null,null,null,null,"O:O","BT:BT",null,null,null,null,null,"Tech/Admin - Senior"]
[null,null,null,null,null,null,null,null,"Q:R",null,null,null,null,null,null,"Super/Mgmt - Entry"]
[null,null,null,null,null,null,null,null,"AA:AE",null,null,null,null,null,null,"Super/Mgmt - Full Perf."]
[null,null,null,null,null,null,null,null,"AG:AG",null,null,null,null,null,null,"Super/Mgmt - Senior"]
[null,null,null,null,null,null,null,null,"AI:AM",null,null,null,null,null,null,"Super/Mgmt - Expert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prof - Entry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prof - Full Perf."]
[null,null,{"$f":"IF(AND(LEN($A12)>0,LEN($B12)>0),CONCATENATE(\"$\",$A12,EndRow,\":\",\"$\",$B12,EndRow),\"\")","v":""},{"$f":"IF(AND(LEN($A12)>0,LEN($B12)>0),CONCATENATE(\"$\",$A12,BeginRow+1,\":\",\"$\",$B12,EndRow-1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Prof - Senior"]
[null,null,"","",null,null,null,null,null,null,null,null,null,null,null,"Prof - Expert"]
[null,null,"",""]
[null,null,"",""]
["EOD < 90 days",null,"",""]
["EOD 90 to 180 days",null,"",""]
["DCIPS transfer In ",null,"",""]
["DCIPS transfer Out ",null,"",""]
["Promoted < 90 days ",null,"",""]
["Occupational Advancement ",null,"",""]
["Developmental/Grandfathered",null,"",""]
["Annuitant",null,"",""]
["Part Time",null,"",""]
["Intermittent/Student",null,"",""]
["Promoted Salary > 8%",null,"",""]
["Promoted to DISES/DISL",null,"",""]
["Long Term Training",null,"",""]
["LWOP",null,"",""]
["Military Service",null,"",""]
["Worker's Compensation",null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
["Consideration for DQI/SQI"]
["Award during the performance year"]
["Prorated for partial year",null,{"$f":"IF(AND(LEN($A44)>0,LEN($B43)>0),CONCATENATE(\"$\",$A44,EndRow,\":\",\"$\",$B43,EndRow),\"\")","v":""},{"$f":"IF(AND(LEN($A44)>0,LEN($B43)>0),CONCATENATE(\"$\",$A44,BeginRow+1,\":\",\"$\",$B43,EndRow-1),\"\")","v":""}]
[]
[null,null,{"$f":"IF(AND(LEN($A44)>0,LEN($B45)>0),CONCATENATE(\"$\",$A44,EndRow,\":\",\"$\",$B45,EndRow),\"\")","v":""},{"$f":"IF(AND(LEN($A44)>0,LEN($B45)>0),CONCATENATE(\"$\",$A44,BeginRow+1,\":\",\"$\",$B45,EndRow-1),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]

{"sheet":"Summary","index":6,"n_rows":4,"n_cols":20,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,{"$f":"MATCH(F$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":47},{"$f":"MATCH(G$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":48},null,{"$f":"MATCH(I$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":61},{"$f":"MATCH(J$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":97},{"$f":"MATCH(K$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":99},{"$f":"MATCH(L$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":100},{"$f":"MATCH(M$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":106},null,null,{"$f":"MATCH(P$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":136},{"$f":"MATCH(Q$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":138},{"$f":"MATCH(R$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":137},{"$f":"MATCH(S$2,'Pay Pool Panel'!$C$11:$EU$11,0)","v":141}]
["Last Name","First Name","Employee ID","Pay Band (as of Extract date)","Wildcard 1","Overall Rating","Evaluation of Record","Base Salary (as of Extract date)","End Cycle Compa Ratio","Floor Salary Incr.\n($)","Perf. Salary Incr.\n($)","Perf. Salary Incr.\n(%)","Amount\nof Other\nIncr.\n($)","Total Salary Incr. ($)\n(Includes Floor & Other)","Total Salary Incr. (%)\n(Includes Floor & Other)","Total Bonus\n($)","Total Bonus (% of Base Salary)","Total Bonus (% of Midpoint)","Estimated  $ Amount of Award","Perm Hidden"]
[null,null,null,null,null,{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,F$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,G$1,FALSE))","v":""},null,{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,I$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,J$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,K$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,L$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,M$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",J3+K3+M3)","v":""},{"$f":"IF(ISBLANK($A3),\"\",$N3/$H3)","v":""},{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,P$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,Q$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,R$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,S$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A3),\"\",SUBSTITUTE(VLOOKUP($C3,'Pay Pool Panel'!$C$12:$FH$13,MATCH(T$2,'Pay Pool Panel'!$C$11:$FH$11,0),FALSE),\"0\",\"\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,F$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,G$1,FALSE))","v":""},null,{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,I$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,J$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,K$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,L$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,M$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",J4+K4+M4)","v":""},{"$f":"IF(ISBLANK($A4),\"\",$N4/$H4)","v":""},{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,P$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,Q$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,R$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,S$1,FALSE))","v":""},{"$f":"IF(ISBLANK($A4),\"\",SUBSTITUTE(VLOOKUP($C4,'Pay Pool Panel'!$C$12:$FH$13,MATCH(T$2,'Pay Pool Panel'!$C$11:$FH$11,0),FALSE),\"0\",\"\"))","v":""}]

{"sheet":"Rating Statistics","index":7,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,4,3,5],[3,3,4,3],[1,2,1,6],[3,2,4,2]]}
[]
[null,null,{"$f":"CONCATENATE(\"Rating Statistics for Pay Pool \",PPID)","v":"Rating Statistics for Pay Pool "}]
[]
[null,null,"Mean Objective Rating","Mean Element Rating","Overall Rating"]
[null,null,null,null,"Mean","Std Dev","Number of Employees","Employees Rated"]
[]
[null,"Entire Pay Pool",{"$f":"IF($H$7=0,\"\",SUMPRODUCT((Rating>0)*ObjRating)/$H$7)","v":""},{"$f":"IF($H$7=0,\"\",SUMPRODUCT((ElementRating>0)*ElementRating)/$H$7)","v":""},{"$f":"IF($H$7=0,\"\",SUMPRODUCT((AverageRating>0)*AverageRating)/$H$7)","v":""},{"$f":"IF($H$7<=1,\"\",STDEV(IF(AverageRating>0,AverageRating,\"\")))","v":""},{"$f":"EmpCount","v":0},{"$f":"COUNTIF(Rating,\">0\")","v":0}]
[null,{"$f":"UseTitle","v":"Grade"}]
[]
[null,null,{"$f":"IF(OR($B10=\"\",$H10=0),\"\",SUMPRODUCT((StatsPPBand=$B10)*(Rating>0)*ObjRating)/$H10)","v":""},{"$f":"IF(OR($B10=\"\",$H10=0),\"\",SUMPRODUCT((StatsPPBand=$B10)*(ElementRating>0)*ElementRating)/$H10)","v":""},{"$f":"IF(OR($B10=\"\",$H10=0),\"\",SUMPRODUCT((StatsPPBand=$B10)*(AverageRating>0)*AverageRating)/$H10)","v":""},{"$f":"IF(OR($H10<=1,$H10=\"\"),\"\",STDEV(IF((StatsPPBand=$B10)*(AverageRating>0),AverageRating,\"\")))","v":""},{"$f":"IF($B10=\"\",\"\",SUMPRODUCT((StatsPPBand=$B10)*1))","v":""},{"$f":"IF($B10=\"\",\"\",SUMPRODUCT((StatsPPBand=$B10)*(Rating>0)))","v":""}]
[null,"Organization ID 1"]
[]
[null,null,{"$f":"IF(OR($B13=\"\",$H13=0),\"\",SUMPRODUCT((OrgID_01=$B13)*(Rating>0)*ObjRating)/$H13)","v":""},{"$f":"IF(OR($B13=\"\",$H13=0),\"\",SUMPRODUCT((OrgID_01=$B13)*(ElementRating>0)*ElementRating)/$H13)","v":""},{"$f":"IF(OR($B13=\"\",$H13=0),\"\",SUMPRODUCT((OrgID_01=$B13)*(AverageRating>0)*AverageRating)/$H13)","v":""},{"$f":"IF(OR($H13<=1,$H13=\"\"),\"\",STDEV(IF((OrgID_01=$B13)*(AverageRating>0),AverageRating,\"\")))","v":""},{"$f":"IF($B13=\"\",\"\",SUMPRODUCT((OrgID_01=$B13)*1))","v":""},{"$f":"IF($B13=\"\",\"\",SUMPRODUCT((OrgID_01=$B13)*(Rating>0)))","v":""}]
[null,"Organization ID 2"]
[]
[null,null,{"$f":"IF(OR($B16=\"\",$H16=0),\"\",SUMPRODUCT((OrgID_02=$B16)*(Rating>0)*ObjRating)/$H16)","v":""},{"$f":"IF(OR($B16=\"\",$H16=0),\"\",SUMPRODUCT((OrgID_02=$B16)*(ElementRating>0)*ElementRating)/$H16)","v":""},{"$f":"IF(OR($B16=\"\",$H16=0),\"\",SUMPRODUCT((OrgID_02=$B16)*(AverageRating>0)*AverageRating)/$H16)","v":""},{"$f":"IF(OR($H16<=1,$H16=\"\"),\"\",STDEV(IF((OrgID_02=$B16)*(AverageRating>0),AverageRating,\"\")))","v":""},{"$f":"IF($B16=\"\",\"\",SUMPRODUCT((OrgID_02=$B16)*1))","v":""},{"$f":"IF($B16=\"\",\"\",SUMPRODUCT((OrgID_02=$B16)*(Rating>0)))","v":""}]
[null,"Reviewing Official"]
[]
[null,null,{"$f":"IF(OR($B19=\"\",$H19=0),\"\",SUMPRODUCT((ReviewingOfficial=$B19)*(Rating>0)*ObjRating)/$H19)","v":""},{"$f":"IF(OR($B19=\"\",$H19=0),\"\",SUMPRODUCT((ReviewingOfficial=$B19)*(ElementRating>0)*ElementRating)/$H19)","v":""},{"$f":"IF(OR($B19=\"\",$H19=0),\"\",SUMPRODUCT((ReviewingOfficial=$B19)*(AverageRating>0)*AverageRating)/$H19)","v":""},{"$f":"IF(OR($H19<=1,$H19=\"\"),\"\",STDEV(IF((ReviewingOfficial=$B19)*(AverageRating>0),AverageRating,\"\")))","v":""},{"$f":"IF($B19=\"\",\"\",SUMPRODUCT((ReviewingOfficial=$B19)*1))","v":""},{"$f":"IF($B19=\"\",\"\",SUMPRODUCT((ReviewingOfficial=$B19)*(Rating>0)))","v":""}]
[null,"Rating Official"]
[]
[null,null,{"$f":"IF(OR($B22=\"\",$H22=0),\"\",SUMPRODUCT((RatingOfficial=$B22)*(Rating>0)*ObjRating)/$H22)","v":""},{"$f":"IF(OR($B22=\"\",$H22=0),\"\",SUMPRODUCT((RatingOfficial=$B22)*(ElementRating>0)*ElementRating)/$H22)","v":""},{"$f":"IF(OR($B22=\"\",$H22=0),\"\",SUMPRODUCT((RatingOfficial=$B22)*(AverageRating>0)*AverageRating)/$H22)","v":""},{"$f":"IF(OR($H22<=1,$H22=\"\"),\"\",STDEV(IF((RatingOfficial=$B22)*(AverageRating>0),AverageRating,\"\")))","v":""},{"$f":"IF($B22=\"\",\"\",SUMPRODUCT((RatingOfficial=$B22)*1))","v":""},{"$f":"IF($B22=\"\",\"\",SUMPRODUCT((RatingOfficial=$B22)*(Rating>0)))","v":""}]
[null,"Work Cat/Level"]
[]
[null,null,{"$f":"IF(OR($B25=\"\",$H25=0),\"\",SUMPRODUCT((CatLev=$B25)*(Rating>0)*ObjRating)/$H25)","v":""},{"$f":"IF(OR($B25=\"\",$H25=0),\"\",SUMPRODUCT((CatLev=$B25)*(ElementRating>0)*ElementRating)/$H25)","v":""},{"$f":"IF(OR($B25=\"\",$H25=0),\"\",SUMPRODUCT((CatLev=$B25)*(AverageRating>0)*AverageRating)/$H25)","v":""},{"$f":"IF(OR($H25<=1,$H25=\"\"),\"\",STDEV(IF((CatLev=$B25)*(AverageRating>0),AverageRating,\"\")))","v":""},{"$f":"IF($B25=\"\",\"\",SUMPRODUCT((CatLev=$B25)*1))","v":""},{"$f":"IF($B25=\"\",\"\",SUMPRODUCT((CatLev=$B25)*(Rating>0)))","v":""}]
[null,"Wildcard"]
[]
[null,null,{"$f":"IF(OR($B28=\"\",$H28=0),\"\",SUMPRODUCT((WildCard=$B28)*(Rating>0)*ObjRating)/$H28)","v":""},{"$f":"IF(OR($B28=\"\",$H28=0),\"\",SUMPRODUCT((WildCard=$B28)*(ElementRating>0)*ElementRating)/$H28)","v":""},{"$f":"IF(OR($B28=\"\",$H28=0),\"\",SUMPRODUCT((WildCard=$B28)*(AverageRating>0)*AverageRating)/$H28)","v":""},{"$f":"IF(OR($H28<=1,$H28=\"\"),\"\",STDEV(IF((WildCard=$B28)*(AverageRating>0),AverageRating,\"\")))","v":""},{"$f":"IF($B28=\"\",\"\",SUMPRODUCT(NOT(ISBLANK(EmployeeID))*(WildCard=$B28)*1))","v":""},{"$f":"IF($B28=\"\",\"\",SUMPRODUCT((WildCard=$B28)*(Rating>0)))","v":""}]

{"sheet":"Rating Charts","index":8,"n_rows":61,"n_cols":28,"rows_kept":61,"cut":false,"hidden":false,"merged":[[29,20,29,25]]}
[null,null,null,null,null,null,null,null,null,"Rating Charts"]
[null,null,null,null,null,null,null,null,null,{"$f":"PPID","v":""},null,null,null,null,null,null,null,null,null,null,"Pick the Pay Plan to Analyze  >>>",null,null,"IA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PI"]
[null,null,"Ratings","Count","Percent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Percent of \", U6)","v":"Percent of Grade"}]
[null,"Unacceptable",1,{"$f":"COUNTIF(Rating,1)","v":0},{"$f":"D6/$D$11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"(0",null,null,null,null,null,null,null,null,{"$f":"IF(isNGAMode,\"Pay Band\",\"Grade\")","v":"Grade"},"Rated 1","Rated 2","Rated 3","Rated 4","Rated 5"]
[null,"Min Successful",2,{"$f":"COUNTIF(Rating,2)","v":0},{"$f":"D7/$D$11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"SUMPRODUCT((PP_Eval=SelPlan)*(Rating=1)*(PayBand=$U7)*1)","v":0},{"$f":"SUMPRODUCT((PP_Eval=SelPlan)*(Rating=2)*(PayBand=$U7)*1)","v":0},{"$f":"SUMPRODUCT((PP_Eval=SelPlan)*(Rating=3)*(PayBand=$U7)*1)","v":0},{"$f":"SUMPRODUCT((PP_Eval=SelPlan)*(Rating=4)*(PayBand=$U7)*1)","v":0},{"$f":"SUMPRODUCT((PP_Eval=SelPlan)*(Rating=5)*(PayBand=$U7)*1)","v":0},{"$f":"SUM(V7:Z7)","v":0}]
[null,"Successful",3,{"$f":"COUNTIF(Rating,3)","v":0},{"$f":"D8/$D$11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0,0,0,0,0,{"$f":"SUM(V8:Z8)","v":0}]
[null,"Excellent",4,{"$f":"COUNTIF(Rating,4)","v":0},{"$f":"D9/$D$11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,0,0,0,0,{"$f":"SUM(V9:Z9)","v":0}]
[null,"Outstanding",5,{"$f":"COUNTIF(Rating,5)","v":0},{"$f":"D10/$D$11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,0,0,0,0,{"$f":"SUM(V10:Z10)","v":0}]
[null,null,"Total",{"$f":"SUM(D6:D10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,0,0,0,0,{"$f":"SUM(V11:Z11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V7:V21)","v":0},{"$f":"SUM(W7:W21)","v":0},{"$f":"SUM(X7:X21)","v":0},{"$f":"SUM(Y7:Y21)","v":0},{"$f":"SUM(Z7:Z21)","v":0},0]
[]
[]
[]
[]
[]
[]
[]
[null,"1.0 to 1.9",{"$f":"SUMPRODUCT((AverageRating>=1)*(AverageRating<2))","v":0},{"$f":"$C30/$E$30","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C30:C61)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"% values for ratings by \",U6)","v":"% values for ratings by Grade"}]
[null,2,{"$f":"COUNTIF(AverageRating,\"=\"&$B31)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U6","v":"Grade"},"Unacceptable","Min Successful","Successful","Excellent","Outstanding"]
[null,2.1,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF($AA7>0,V7/$AA7,\"\")","v":""},"","","",""]
[null,2.2000000000000002,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"","","","",""]
[null,2.2999999999999998,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"","","","",""]
[null,2.4,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"","","","",""]
[null,2.5,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"","","","",""]
[null,2.6,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"","","","",""]
[null,2.7,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"","","","",""]
[null,2.8,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"","","","",""]
[null,2.9,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"","","","",""]
[null,3,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"","","","",""]
[null,3.1,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"","","","",""]
[null,3.2,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"","","","",""]
[null,3.3,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"","","","",""]
[null,3.4,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF($AA20>0,V20/$AA20,\"\")","v":""},"","","",""]
[null,3.5,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","","","",""]
[null,3.6,0,{"$error":"#DIV/0!"}]
[null,3.7,0,{"$error":"#DIV/0!"}]
[null,3.8,0,{"$error":"#DIV/0!"}]
[null,3.9,0,{"$error":"#DIV/0!"}]
[null,4,0,{"$error":"#DIV/0!"}]
[null,4.0999999999999996,0,{"$error":"#DIV/0!"}]
[null,4.2,0,{"$error":"#DIV/0!"}]
[null,4.3,0,{"$error":"#DIV/0!"}]
[null,4.4000000000000004,0,{"$error":"#DIV/0!"}]
[null,4.5,0,{"$error":"#DIV/0!"}]
[null,4.5999999999999996,0,{"$error":"#DIV/0!"}]
[null,4.7,0,{"$error":"#DIV/0!"}]
[null,4.8,0,{"$error":"#DIV/0!"}]
[null,4.9000000000000004,0,{"$error":"#DIV/0!"}]
[null,5,0,{"$error":"#DIV/0!"}]

{"sheet":"Hidden Sal Inc Rates","index":9,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[null,"Rating Range","Payout Range",null,null,"Bonus Share Info"]
["Low",2.6,0]
["High",5,0.06,null,null,"Min Shares",1]
["Range",{"$f":"B3-B2","v":2.4},0.06,null,null,"Total Shares",{"$f":"SUM(BonusSharesFinal)","v":0}]
["Incr",0.1,null,null,null,"Share Value",{"$f":"IF(OR(SumBonusElig=0,'Hidden Sal Inc Rates'!G4=0),0,MAX(0,(bonusfund+IF(BonAdjust<0,-BonAdjust,IF(BonAdjPot<0,BonAdjPot,0))))/SUMPRODUCT(BandMidpoints,BonusSharesFinal))","v":0}]
["# of Incr",{"$f":"1+B4/B5","v":24.999999999999996}]
["Increment",{"$f":"C4/B6","v":2.4000000000000002E-3}]
[]
[]
[]
[null,null,null,null,null,"Bonus Share Table"]
[null,null,null,null,null,"Rating Lookup","Shares","Ratio of next higher rating"]
[null,null,null,null,null,2.6,{"$f":"ROUND(IF(F13=BonusThreshold,$G$3,IF(F13>BonusThreshold,G12*(1+Export_24),0)),2)","v":0}]
[null,null,null,null,null,2.7,0,{"$f":"IF(G13=0,0,(G14-G13)/G13)","v":0}]
[null,null,null,null,null,2.8,0,0]
[null,null,null,null,null,2.9,0,0]
[null,null,null,null,null,3,0,0]
[null,null,null,null,null,3.1,0,0]
[null,null,null,null,null,3.2,0,0]
[null,null,null,null,null,3.3,0,0]
[null,null,null,null,null,3.4,0,0]
[null,null,null,null,null,3.5,1,0]
[null,null,null,null,null,3.6,1.1000000000000001,0.10000000000000009]
[null,null,null,null,null,3.7,1.21,9.9999999999999881E-2]
[null,null,null,null,null,3.8,1.33,9.917355371900835E-2]
[null,null,null,null,null,3.9,1.46,9.774436090225555E-2]
[null,null,null,null,null,4,1.61,0.10273972602739735]
[null,null,null,null,null,4.0999999999999996,1.77,9.9378881987577578E-2]
[null,null,null,null,null,4.2,1.95,0.10169491525423725]
[null,null,null,null,null,4.3,2.15,0.10256410256410255]
[null,null,null,null,null,4.4000000000000004,2.37,0.10232558139534893]
[null,null,null,null,null,4.5,2.61,0.10126582278481003]
[null,null,null,null,null,4.5999999999999996,2.87,9.9616858237547984E-2]
[null,null,null,null,null,4.7,3.16,0.10104529616724739]
[null,null,null,null,null,4.8,3.48,0.10126582278481007]
[null,null,null,null,null,4.9000000000000004,3.83,0.10057471264367819]
[null,null,null,null,null,5,4.21,9.9216710182767592E-2]

{"sheet":"Salary Increase Statistics","index":10,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[2,10,3,10],[1,4,1,8],[2,2,3,2],[2,11,3,11],[2,7,3,7],[2,8,3,8],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,9,3,9]]}
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Salary Increase Statistics for Pay Pool \",PPID)","v":"Salary Increase Statistics for Pay Pool "}]
[null,null,null,null,"Mean Statistics include only employees receiving a salary increase"]
[null,null,"Mean Overall Rating","Mean Base Salary","Mean\nCompa Ratio","Mean Perf. Salary Increase\n($)","Mean Perf. Salary Increase\n(%)","Mean Total Salary Increase\n($)","Mean Total Salary Increase\n(%)","Total Number\nof\nEmployees","Number of Employees Rated and Eligible","Employees Rcv Perf Salary Increase"]
[]
[]
[null,"Entire Pay Pool",{"$f":"IF($K6=0,\"\",SUMPRODUCT((UseInAnalysis=1)*AverageRating)/$K6)","v":""},{"$f":"IF($K6=0,\"\",SUMPRODUCT((UseInAnalysis=1)*BasePay)/$K6)","v":""},{"$f":"IF($K6=0,\"\",SUMPRODUCT((UseInAnalysis=1)*CompaRatio)/$K6)","v":""},{"$f":"IF($K6=0,\"\",SUMPRODUCT((UseInAnalysis=1)*FinalSalIncDoll)/$K6)","v":""},{"$f":"IF($K6=0,\"\",SUMPRODUCT((UseInAnalysis=1)*FinalSalIncPer)/$K6)","v":""},{"$f":"IF($K6=0,\"\",SUMPRODUCT((UseInAnalysis=1)*TotalSalIncDol)/$K6)","v":""},{"$f":"IF($K6=0,\"\",SUMPRODUCT((UseInAnalysis=1)*TotalSalIncPer)/$K6)","v":""},{"$f":"EmpCount","v":0},{"$f":"COUNTIF(UseInAnalysis,\"=1\")","v":0},{"$f":"COUNTIF(FinalSalIncDoll,\">0\")","v":0}]
[null,"Pay Band"]
[]
[null,null,{"$f":"IF(OR($B9=\"\",$L9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(UseInAnalysis=1)*AverageRating)/$K9)","v":""},{"$f":"IF(OR($B9=\"\",$L9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(UseInAnalysis=1)*BasePay)/$K9)","v":""},{"$f":"IF(OR($B9=\"\",$L9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(UseInAnalysis)*CompaRatio)/$K9)","v":""},{"$f":"IF(OR($B9=\"\",$L9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(FinalSalIncDoll))/$K9)","v":""},{"$f":"IF(OR($B9=\"\",$L9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(FinalSalIncPer))/$K9)","v":""},{"$f":"IF(OR($B9=\"\",$L9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(UseInAnalysis=1)*TotalSalIncDol)/$K9)","v":""},{"$f":"IF(OR($B9=\"\",$L9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(UseInAnalysis=1)*TotalSalIncPer)/$K9)","v":""},{"$f":"IF($B9=\"\",\"\",SUMPRODUCT((StatsPPBand=$B9)*1))","v":""},{"$f":"IF($B9=\"\",\"\",SUMPRODUCT((StatsPPBand=$B9)*(UseInAnalysis=1)))","v":""},{"$f":"IF($B9=\"\",\"\",SUMPRODUCT((StatsPPBand=$B9)*(FinalSalIncDoll>0)))","v":""}]
[null,"Organization ID 1"]
[]
[null,null,{"$f":"IF(OR($B12=\"\",$L12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(UseInAnalysis=1)*AverageRating)/$K12)","v":""},{"$f":"IF(OR($B12=\"\",$L12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(UseInAnalysis=1)*BasePay)/$K12)","v":""},{"$f":"IF(OR($B12=\"\",$L12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(UseInAnalysis)*CompaRatio)/$K12)","v":""},{"$f":"IF(OR($B12=\"\",$L12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(FinalSalIncDoll))/$K12)","v":""},{"$f":"IF(OR($B12=\"\",$L12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(FinalSalIncPer))/$K12)","v":""},{"$f":"IF(OR($B12=\"\",$L12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(UseInAnalysis=1)*TotalSalIncDol)/$K12)","v":""},{"$f":"IF(OR($B12=\"\",$L12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(UseInAnalysis=1)*TotalSalIncPer)/$K12)","v":""},{"$f":"IF($B12=\"\",\"\",SUMPRODUCT((OrgID_01=$B12)*1))","v":""},{"$f":"IF($B12=\"\",\"\",SUMPRODUCT((OrgID_01=$B12)*(UseInAnalysis=1)))","v":""},{"$f":"IF($B12=\"\",\"\",SUMPRODUCT((OrgID_01=$B12)*(FinalSalIncDoll>0)))","v":""}]
[null,"Organization ID 2"]
[]
[null,null,{"$f":"IF(OR($B15=\"\",$L15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(UseInAnalysis=1)*AverageRating)/$K15)","v":""},{"$f":"IF(OR($B15=\"\",$L15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(UseInAnalysis=1)*BasePay)/$K15)","v":""},{"$f":"IF(OR($B15=\"\",$L15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(UseInAnalysis)*CompaRatio)/$K15)","v":""},{"$f":"IF(OR($B15=\"\",$L15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(FinalSalIncDoll))/$K15)","v":""},{"$f":"IF(OR($B15=\"\",$L15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(FinalSalIncPer))/$K15)","v":""},{"$f":"IF(OR($B15=\"\",$L15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(UseInAnalysis=1)*TotalSalIncDol)/$K15)","v":""},{"$f":"IF(OR($B15=\"\",$L15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(UseInAnalysis=1)*TotalSalIncPer)/$K15)","v":""},{"$f":"IF($B15=\"\",\"\",SUMPRODUCT((OrgID_02=$B15)*1))","v":""},{"$f":"IF($B15=\"\",\"\",SUMPRODUCT((OrgID_02=$B15)*(UseInAnalysis=1)))","v":""},{"$f":"IF($B15=\"\",\"\",SUMPRODUCT((OrgID_02=$B15)*(FinalSalIncDoll>0)))","v":""}]
[null,"Reviewing Official"]
[]
[null,null,{"$f":"IF(OR($B18=\"\",$L18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(UseInAnalysis=1)*AverageRating)/$K18)","v":""},{"$f":"IF(OR($B18=\"\",$L18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(UseInAnalysis=1)*BasePay)/$K18)","v":""},{"$f":"IF(OR($B18=\"\",$L18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(UseInAnalysis)*CompaRatio)/$K18)","v":""},{"$f":"IF(OR($B18=\"\",$L18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(FinalSalIncDoll))/$K18)","v":""},{"$f":"IF(OR($B18=\"\",$L18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(FinalSalIncPer))/$K18)","v":""},{"$f":"IF(OR($B18=\"\",$L18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(UseInAnalysis=1)*TotalSalIncDol)/$K18)","v":""},{"$f":"IF(OR($B18=\"\",$L18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(UseInAnalysis=1)*TotalSalIncPer)/$K18)","v":""},{"$f":"IF($B18=\"\",\"\",SUMPRODUCT((ReviewingOfficial=$B18)*1))","v":""},{"$f":"IF($B18=\"\",\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(UseInAnalysis=1)))","v":""},{"$f":"IF($B18=\"\",\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(FinalSalIncDoll>0)))","v":""}]
[null,"Rating Official"]
[]
[null,null,{"$f":"IF(OR($B21=\"\",$L21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(UseInAnalysis=1)*AverageRating)/$K21)","v":""},{"$f":"IF(OR($B21=\"\",$L21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(UseInAnalysis=1)*BasePay)/$K21)","v":""},{"$f":"IF(OR($B21=\"\",$L21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(UseInAnalysis)*CompaRatio)/$K21)","v":""},{"$f":"IF(OR($B21=\"\",$L21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(FinalSalIncDoll))/$K21)","v":""},{"$f":"IF(OR($B21=\"\",$L21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(FinalSalIncPer))/$K21)","v":""},{"$f":"IF(OR($B21=\"\",$L21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(UseInAnalysis=1)*TotalSalIncDol)/$K21)","v":""},{"$f":"IF(OR($B21=\"\",$L21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(UseInAnalysis=1)*TotalSalIncPer)/$K21)","v":""},{"$f":"IF($B21=\"\",\"\",SUMPRODUCT((RatingOfficial=$B21)*1))","v":""},{"$f":"IF($B21=\"\",\"\",SUMPRODUCT((RatingOfficial=$B21)*(UseInAnalysis=1)))","v":""},{"$f":"IF($B21=\"\",\"\",SUMPRODUCT((RatingOfficial=$B21)*(FinalSalIncDoll>0)))","v":""}]
[null,"Work Category"]
[]
[null,null,{"$f":"IF(OR($B24=\"\",$L24=0),\"\",SUMPRODUCT((CatLev=$B24)*(UseInAnalysis=1)*AverageRating)/$K24)","v":""},{"$f":"IF(OR($B24=\"\",$L24=0),\"\",SUMPRODUCT((CatLev=$B24)*(UseInAnalysis=1)*BasePay)/$K24)","v":""},{"$f":"IF(OR($B24=\"\",$L24=0),\"\",SUMPRODUCT((CatLev=$B24)*(UseInAnalysis)*CompaRatio)/$K24)","v":""},{"$f":"IF(OR($B24=\"\",$L24=0),\"\",SUMPRODUCT((CatLev=$B24)*(FinalSalIncDoll))/$K24)","v":""},{"$f":"IF(OR($B24=\"\",$L24=0),\"\",SUMPRODUCT((CatLev=$B24)*(FinalSalIncPer))/$K24)","v":""},{"$f":"IF(OR($B24=\"\",$L24=0),\"\",SUMPRODUCT((CatLev=$B24)*(UseInAnalysis=1)*TotalSalIncDol)/$K24)","v":""},{"$f":"IF(OR($B24=\"\",$L24=0),\"\",SUMPRODUCT((CatLev=$B24)*(UseInAnalysis=1)*TotalSalIncPer)/$K24)","v":""},{"$f":"IF($B24=\"\",\"\",SUMPRODUCT((CatLev=$B24)*1))","v":""},{"$f":"IF($B24=\"\",\"\",SUMPRODUCT((CatLev=$B24)*(UseInAnalysis=1)))","v":""},{"$f":"IF($B24=\"\",\"\",SUMPRODUCT((CatLev=$B24)*(FinalSalIncDoll>0)))","v":""}]
[null,"Wildcard"]
[]
[null,null,{"$f":"IF(OR($B27=\"\",$L27=0),\"\",SUMPRODUCT((WildCard=$B27)*(UseInAnalysis=1)*AverageRating)/$K27)","v":""},{"$f":"IF(OR($B27=\"\",$L27=0),\"\",SUMPRODUCT((WildCard=$B27)*(UseInAnalysis=1)*BasePay)/$K27)","v":""},{"$f":"IF(OR($B27=\"\",$L27=0),\"\",SUMPRODUCT((WildCard=$B27)*(UseInAnalysis)*CompaRatio)/$K27)","v":""},{"$f":"IF(OR($B27=\"\",$L27=0),\"\",SUMPRODUCT((WildCard=$B27)*(FinalSalIncDoll))/$K27)","v":""},{"$f":"IF(OR($B27=\"\",$L27=0),\"\",SUMPRODUCT((WildCard=$B27)*(FinalSalIncPer))/$K27)","v":""},{"$f":"IF(OR($B27=\"\",$L27=0),\"\",SUMPRODUCT((WildCard=$B27)*(UseInAnalysis=1)*TotalSalIncDol)/$K27)","v":""},{"$f":"IF(OR($B27=\"\",$L27=0),\"\",SUMPRODUCT((WildCard=$B27)*(UseInAnalysis=1)*TotalSalIncPer)/$K27)","v":""},{"$f":"IF($B27=\"\",\"\",SUMPRODUCT((WildCard=$B27)*1))","v":""},{"$f":"IF($B27=\"\",\"\",SUMPRODUCT((WildCard=$B27)*(UseInAnalysis=1)))","v":""},{"$f":"IF($B27=\"\",\"\",SUMPRODUCT((WildCard=$B27)*(FinalSalIncDoll>0)))","v":""}]

{"sheet":"Hidden Combo Chart","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Salary Increase Charts","index":12,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Salary Increase Charts"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"PPID","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"% for Salary","Count for Salary"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"0 to 1 %",{"$f":"IF($K$20>0,$K9/$K$20)","v":false},{"$f":"SUMPRODUCT((FinalSalIncPer>L8)*(FinalSalIncPer<=L9))","v":0},0.01]
[null,null,null,null,null,null,null,null,"1 to 2%",false,0,0.02]
[null,null,null,null,null,null,null,null,"2 to 3%",false,0,0.03]
[null,null,null,null,null,null,null,null,"3 to 4%",false,0,0.04]
[null,null,null,null,null,null,null,null,"4 to 5%",false,0,0.05]
[null,null,null,null,null,null,null,null,"5 to 6%",false,0,0.06]
[null,null,null,null,null,null,null,null,"6 to 7%",false,0,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,"7 to 8%",false,0,0.08]
[null,null,null,null,null,null,null,null,"8 to 9%",false,0,0.09]
[null,null,null,null,null,null,null,null,"9 to 10%",false,{"$f":"SUMPRODUCT((FinalSalIncPer>L17)*(FinalSalIncPer<=L18))","v":0},0.1]
[null,null,null,null,null,null,null,null,"Above 10%",false,{"$f":"COUNTIF(FinalSalIncPer,\">\"&L18)","v":0}]
[null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(K9:K19)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,0,{"$f":"PO_SalDol_Overall","v":""},null,null,null,null,null,null,null,null,0,{"$f":"AvgSalInc","v":""}]
[null,null,1,{"$f":"PO_SalDol_Overall","v":""},null,null,null,null,null,null,null,null,1,{"$f":"AvgSalInc","v":""}]

{"sheet":"Total Salary Increase Charts","index":13,"n_rows":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Total Salary Increase Charts"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"PPID","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,"% for Salary","Count for Salary"]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,"0 to 1 %",{"$f":"IF($J$18>0,$J7/$J$18)","v":false},{"$f":"SUMPRODUCT((TotalSalIncPer>K6)*(TotalSalIncPer<=K7))","v":0},0.01]
[null,null,null,null,null,null,null,"1 to 2%",false,0,0.02]
[null,null,null,null,null,null,null,"2 to 3%",false,0,0.03]
[null,null,null,null,null,null,null,"3 to 4%",false,0,0.04]
[null,null,null,null,null,null,null,"4 to 5%",false,0,0.05]
[null,null,null,null,null,null,null,"5 to 6%",false,0,0.06]
[null,null,null,null,null,null,null,"6 to 7%",false,0,7.0000000000000007E-2]
[null,null,null,null,null,null,null,"7 to 8%",false,0,0.08]
[null,null,null,null,null,null,null,"8 to 9%",false,0,0.09]
[null,null,null,null,null,null,null,"9 to 10%",false,{"$f":"SUMPRODUCT((TotalSalIncPer>K15)*(TotalSalIncPer<=K16))","v":0},0.1]
[null,null,null,null,null,null,null,"Above 10%",false,{"$f":"COUNTIF(TotalSalIncPer,\">\"&K16)","v":0}]
[null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(J7:J17)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Mean Total Salary Increase % by \" & 'Pay Pool Panel'!$B25","v":"Mean Total Salary Increase % by Grade"}]
[null,null,0,{"$f":"PO_TotDol_Overall","v":""},null,null,null,null,null,null,null,null,0,{"$f":"PO_TotPct_Overall","v":""}]
[null,null,1,{"$f":"PO_TotDol_Overall","v":""},null,null,null,null,null,null,null,null,1,{"$f":"PO_TotPct_Overall","v":""}]

{"sheet":"Bonus Statistics","index":14,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Bonus Statistics"]
[null,null,null,null,null,"Includes Employees Receiving a Bonus"]
[]
[null,null,"Mean Overall Rating","Mean Base Salary","Mean\nCompa Ratio","Mean Bonus ($)","Mean Bonus (% of Midpoint)","Employees Rated","Number of Employees Rated and Bonus Eligible","Employees Receiving Bonus","Pct of Employees with Bonus"]
[]
[null,"Entire Pay Pool",{"$f":"IF($J6=0,\"\",SUMPRODUCT((TotalBonus>0)*AverageRating)/$J6)","v":""},{"$f":"IF($J6=0,\"\",SUMPRODUCT((TotalBonus>0)*BasePay)/$J6)","v":""},{"$f":"IF($J6=0,\"\",SUMPRODUCT((TotalBonus>0)*CompaRatio)/$J6)","v":""},{"$f":"IF($J6=0,\"\",SUM(TotalBonus)/$J6)","v":""},{"$f":"IF($J6=0,\"\",SUM(TotalBonusPer)/$J6)","v":""},{"$f":"COUNTIF(Rating,\">0\")","v":0},{"$f":"SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*1)","v":0},{"$f":"COUNTIF(TotalBonus,\">0\")","v":0},{"$f":"IF($I6=0,\"\",$J6/$I6)","v":""}]
[null,{"$f":"UseTitle","v":"Grade"}]
[]
[null,null,{"$f":"IF(OR($B9=\"\",$J9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(TotalBonus>0)*AverageRating)/$J9)","v":""},{"$f":"IF(OR($B9=\"\",$J9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(TotalBonus>0)*BasePay)/$J9)","v":""},{"$f":"IF(OR($B9=\"\",$J9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(TotalBonus>0)*CompaRatio)/$J9)","v":""},{"$f":"IF(OR($B9=\"\",$J9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(TotalBonus))/$J9)","v":""},{"$f":"IF(OR($B9=\"\",$J9=0),\"\",SUMPRODUCT((StatsPPBand=$B9)*(TotalBonusPer))/$J9)","v":""},{"$f":"IF($B9=\"\",\"\",SUMPRODUCT((StatsPPBand=$B9)*(Rating>0)))","v":""},{"$f":"IF($B9=\"\",\"\",SUMPRODUCT((StatsPPBand>0)*(BonusEligible=\"Yes\")*(PayBand=$B9)*1))","v":""},{"$f":"IF($B9=\"\",\"\",SUMPRODUCT((StatsPPBand=$B9)*(TotalBonus>0)))","v":""},{"$f":"IF(OR($I9=0,$B9=\"\"),\"\",$J9/$I9)","v":""}]
[null,"Organization ID 1"]
[]
[null,null,{"$f":"IF(OR($B12=\"\",$J12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(TotalBonus>0)*AverageRating)/$J12)","v":""},{"$f":"IF(OR($B12=\"\",$J12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(TotalBonus>0)*BasePay)/$J12)","v":""},{"$f":"IF(OR($B12=\"\",$J12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(TotalBonus>0)*CompaRatio)/$J12)","v":""},{"$f":"IF(OR($B12=\"\",$J12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(TotalBonus))/$J12)","v":""},{"$f":"IF(OR($B12=\"\",$J12=0),\"\",SUMPRODUCT((OrgID_01=$B12)*(TotalBonusPer))/$J12)","v":""},{"$f":"IF($B12=\"\",\"\",SUMPRODUCT((OrgID_01=$B12)*(Rating>0)))","v":""},{"$f":"IF($B12=\"\",\"\",SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*(OrgID_01=$B12)*1))","v":""},{"$f":"IF($B12=\"\",\"\",SUMPRODUCT((OrgID_01=$B12)*(TotalBonus>0)))","v":""},{"$f":"IF(OR($I12=0,$B12=\"\"),\"\",$J12/$I12)","v":""}]
[null,"Organization ID 2"]
[]
[null,null,{"$f":"IF(OR($B15=\"\",$J15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(TotalBonus>0)*AverageRating)/$J15)","v":""},{"$f":"IF(OR($B15=\"\",$J15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(TotalBonus>0)*BasePay)/$J15)","v":""},{"$f":"IF(OR($B15=\"\",$J15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(TotalBonus>0)*CompaRatio)/$J15)","v":""},{"$f":"IF(OR($B15=\"\",$J15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(TotalBonus))/$J15)","v":""},{"$f":"IF(OR($B15=\"\",$J15=0),\"\",SUMPRODUCT((OrgID_02=$B15)*(TotalBonusPer))/$J15)","v":""},{"$f":"IF($B15=\"\",\"\",SUMPRODUCT((OrgID_02=$B15)*(Rating>0)))","v":""},{"$f":"IF($B15=\"\",\"\",SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*(OrgID_02=$B15)*1))","v":""},{"$f":"IF($B15=\"\",\"\",SUMPRODUCT((OrgID_02=$B15)*(TotalBonus>0)))","v":""},{"$f":"IF(OR($I15=0,$B15=\"\"),\"\",$J15/$I15)","v":""}]
[null,"Reviewing Official"]
[]
[null,null,{"$f":"IF(OR($B18=\"\",$J18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(TotalBonus>0)*AverageRating)/$J18)","v":""},{"$f":"IF(OR($B18=\"\",$J18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(TotalBonus>0)*BasePay)/$J18)","v":""},{"$f":"IF(OR($B18=\"\",$J18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(TotalBonus>0)*CompaRatio)/$J18)","v":""},{"$f":"IF(OR($B18=\"\",$J18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(TotalBonus))/$J18)","v":""},{"$f":"IF(OR($B18=\"\",$J18=0),\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(TotalBonusPer))/$J18)","v":""},{"$f":"IF($B18=\"\",\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(Rating>0)))","v":""},{"$f":"IF($B18=\"\",\"\",SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*(ReviewingOfficial=$B18)*1))","v":""},{"$f":"IF($B18=\"\",\"\",SUMPRODUCT((ReviewingOfficial=$B18)*(TotalBonus>0)))","v":""},{"$f":"IF(OR($I18=0,$B18=\"\"),\"\",$J18/$I18)","v":""}]
[null,"Rating Official"]
[]
[null,null,{"$f":"IF(OR($B21=\"\",$J21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(TotalBonus>0)*AverageRating)/$J21)","v":""},{"$f":"IF(OR($B21=\"\",$J21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(TotalBonus>0)*BasePay)/$J21)","v":""},{"$f":"IF(OR($B21=\"\",$J21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(TotalBonus>0)*CompaRatio)/$J21)","v":""},{"$f":"IF(OR($B21=\"\",$J21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(TotalBonus))/$J21)","v":""},{"$f":"IF(OR($B21=\"\",$J21=0),\"\",SUMPRODUCT((RatingOfficial=$B21)*(TotalBonusPer))/$J21)","v":""},{"$f":"IF($B21=\"\",\"\",SUMPRODUCT((RatingOfficial=$B21)*(Rating>0)))","v":""},{"$f":"IF($B21=\"\",\"\",SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*(RatingOfficial=$B21)*1))","v":""},{"$f":"IF($B21=\"\",\"\",SUMPRODUCT((RatingOfficial=$B21)*(TotalBonus>0)))","v":""},{"$f":"IF(OR($I21=0,$B21=\"\"),\"\",$J21/$I21)","v":""}]
[null,"Work Cat/Level"]
[]
[null,null,{"$f":"IF(OR($B24=\"\",$J24=0),\"\",SUMPRODUCT((CatLev=$B24)*(TotalBonus>0)*AverageRating)/$J24)","v":""},{"$f":"IF(OR($B24=\"\",$J24=0),\"\",SUMPRODUCT((CatLev=$B24)*(TotalBonus>0)*BasePay)/$J24)","v":""},{"$f":"IF(OR($B24=\"\",$J24=0),\"\",SUMPRODUCT((CatLev=$B24)*(TotalBonus>0)*CompaRatio)/$J24)","v":""},{"$f":"IF(OR($B24=\"\",$J24=0),\"\",SUMPRODUCT((CatLev=$B24)*(TotalBonus))/$J24)","v":""},{"$f":"IF(OR($B24=\"\",$J24=0),\"\",SUMPRODUCT((CatLev=$B24)*(TotalBonusPer))/$J24)","v":""},{"$f":"IF($B24=\"\",\"\",SUMPRODUCT((CatLev=$B24)*(Rating>0)))","v":""},{"$f":"IF($B24=\"\",\"\",SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*(CatLev=$B24)*1))","v":""},{"$f":"IF($B24=\"\",\"\",SUMPRODUCT((CatLev=$B24)*(TotalBonus>0)))","v":""},{"$f":"IF(OR($I24=0,$B24=\"\"),\"\",$J24/$I24)","v":""}]
[null,"Wildcard"]
[]
[null,null,{"$f":"IF(OR($B27=\"\",$J27=0),\"\",SUMPRODUCT((WildCard=B27)*(TotalBonus>0)*AverageRating)/$J27)","v":""},{"$f":"IF(OR($B27=\"\",$J27=0),\"\",SUMPRODUCT((WildCard=$B27)*(TotalBonus>0)*BasePay)/$J27)","v":""},{"$f":"IF(OR($B27=\"\",$J27=0),\"\",SUMPRODUCT((WildCard=$B27)*(TotalBonus>0)*CompaRatio)/$J27)","v":""},{"$f":"IF(OR($B27=\"\",$J27=0),\"\",SUMPRODUCT((WildCard=$B27)*(TotalBonus))/$J27)","v":""},{"$f":"IF(OR($B27=\"\",$J27=0),\"\",SUMPRODUCT((WildCard=$B27)*(TotalBonusPer))/$J27)","v":""},{"$f":"IF($B27=\"\",\"\",SUMPRODUCT((WildCard=$B27)*(Rating>0)))","v":""},{"$f":"IF($B27=\"\",\"\",SUMPRODUCT((Rating>0)*(BonusEligible=\"Yes\")*(WildCard=$B27)*1))","v":""},{"$f":"IF($B27=\"\",\"\",SUMPRODUCT((WildCard=$B27)*(TotalBonus>0)))","v":""},{"$f":"IF(OR($I27=0,$B27=\"\"),\"\",$J27/$I27)","v":""}]

{"sheet":"Bonus Charts","index":15,"n_rows":138,"n_cols":13,"rows_kept":138,"cut":false,"hidden":false,"merged":[[1,9,1,10]]}
[null,null,null,null,null,null,null,null,null,"Bonus Charts"]
[null,null,null,null,null,null,null,null,null,{"$f":"PPID","v":""}]
[]
[null,null,"% of Midpoint","Count for Midpoint","% for Salary","Count for Bonus"]
[null,null,null,null,null,null,0]
[null,"0 to 1 %",{"$f":"IF($D$17>0,$D6/$D$17)","v":false},{"$f":"SUMPRODUCT((TotalBonusPer>G5)*(TotalBonusPer<=G6))","v":0},{"$f":"IF($F$17>0,$F6/$F$17)","v":false},{"$f":"SUMPRODUCT((TotalBonusPerBP>G5)*(TotalBonusPerBP<=G6))","v":0},0.01]
[null,"1 to 2%",false,0,false,0,0.02]
[null,"2 to 3%",false,0,false,0,0.03]
[null,"3 to 4%",false,0,false,0,0.04]
[null,"4 to 5%",false,{"$f":"SUMPRODUCT((TotalBonusPer>G9)*(TotalBonusPer<=G10))","v":0},false,0,0.05]
[null,"5 to 6%",false,{"$f":"SUMPRODUCT((TotalBonusPer>G10)*(TotalBonusPer<=G11))","v":0},false,0,0.06]
[null,"6 to 7%",false,{"$f":"SUMPRODUCT((TotalBonusPer>G11)*(TotalBonusPer<=G12))","v":0},false,0,7.0000000000000007E-2]
[null,"7 to 8%",false,{"$f":"SUMPRODUCT((TotalBonusPer>G12)*(TotalBonusPer<=G13))","v":0},false,0,0.08]
[null,"8 to 9%",false,{"$f":"SUMPRODUCT((TotalBonusPer>G13)*(TotalBonusPer<=G14))","v":0},false,0,0.09]
[null,"9 to 10%",false,0,false,0,0.1]
[null,"Above 10%",false,{"$f":"COUNTIF(TotalBonusPer,\">\"&G15)","v":0},false,{"$f":"COUNTIF(TotalBonusPerBP,\">\"&G15)","v":0}]
[null,"Total",null,{"$f":"SUM(D6:D16)","v":0},null,{"$f":"SUM(F6:F16)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,0]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"ct Bonus","Avg$ Bonus"]
[null,"Unacceptable",null,1,{"$f":"SUMPRODUCT((Rating=D61)*(TotalBonus>0))","v":0},{"$f":"SUMPRODUCT((Rating=D61)*(TotalBonus))/MAX(1,E61)","v":0}]
[null,"Min Successful",null,2,{"$f":"SUMPRODUCT((Rating=D62)*(TotalBonus>0))","v":0},{"$f":"SUMPRODUCT((Rating=D62)*(TotalBonus))/MAX(1,E62)","v":0}]
[null,"Successful",null,3,{"$f":"SUMPRODUCT((Rating=D63)*(TotalBonus>0))","v":0},{"$f":"SUMPRODUCT((Rating=D63)*(TotalBonus))/MAX(1,E63)","v":0}]
[null,"Excellent",null,4,{"$f":"SUMPRODUCT((Rating=D64)*(TotalBonus>0))","v":0},{"$f":"SUMPRODUCT((Rating=D64)*(TotalBonus))/MAX(1,E64)","v":0}]
[null,"Outstanding",null,5,{"$f":"SUMPRODUCT((Rating=D65)*(TotalBonus>0))","v":0},{"$f":"SUMPRODUCT((Rating=D65)*(TotalBonus))/MAX(1,E65)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Mean Bonus $ by \" & 'Pay Pool Panel'!$B25","v":"Mean Bonus $ by Grade"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Mean Bonus % by \" & 'Pay Pool Panel'!$B25","v":"Mean Bonus % by Grade"}]
[]
[]
[]
[]
[]
[null,null,0,{"$f":"AvgBonus","v":""},null,null,null,null,null,null,null,0,{"$f":"PO_BonPct_Overall","v":""}]
[null,null,1,{"$f":"AvgBonus","v":""},null,null,null,null,null,null,null,1,{"$f":"PO_BonPct_Overall","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1.0 to 1.9",{"$f":"SUMPRODUCT((AverageRating>=1)*(AverageRating<2)*(TotalBonus>0))","v":0},{"$f":"SUMPRODUCT((AverageRating>=1)*(AverageRating<2)*(TotalBonus))","v":0},{"$f":"IF(C107=0,0,D107/C107)","v":0},{"$f":"SUM(C107:C138)","v":0}]
[null,2,{"$f":"SUMPRODUCT((AverageRating=B108)*(TotalBonus>0))","v":0},{"$f":"SUMPRODUCT((AverageRating=B108)*(TotalBonus))","v":0},{"$f":"IF(C108=0,0,D108/C108)","v":0}]
[null,2.1,0,0,0]
[null,2.2000000000000002,0,0,0]
[null,2.2999999999999998,0,0,0]
[null,2.4,0,0,0]
[null,2.5,0,0,0]
[null,2.6,0,0,0]
[null,2.7,0,0,0]
[null,2.8,0,0,0]
[null,2.9,0,0,0]
[null,3,0,0,0]
[null,3.1,0,0,0]
[null,3.2,0,0,0]
[null,3.3,0,0,0]
[null,3.4,0,0,0]
[null,3.5,0,0,0]
[null,3.6,0,0,0]
[null,3.7,0,0,0]
[null,3.8,0,0,0]
[null,3.9,0,0,0]
[null,4,0,0,0]
[null,4.0999999999999996,0,0,0]
[null,4.2,0,0,0]
[null,4.3,0,0,0]
[null,4.4000000000000004,0,0,0]
[null,4.5,0,0,0]
[null,4.5999999999999996,0,0,0]
[null,4.7,0,0,0]
[null,4.8,0,0,0]
[null,4.9000000000000004,0,0,0]
[null,5,0,0,0]

{"sheet":"OpenSheet","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hidden Work","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Hidden Employee Notices","index":18,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":true,"merged":[[6,2,6,13],[20,2,30,6],[20,18,33,22]]}
[null,"Employee Performance Pay Feedback (estimate*)"]
[]
[null,null,"Name:",null,"Leah Yung",null,"Work Role:","Electronics Engineer",null,null,null,null,"Appraisal Period:"]
[null,null,"Organization:",null,"OFC/CCC",null,"Work Category:","Professional",null,null,null,null,"1-Oct-14 to 30-Sep-15"]
[null,null,"Pay Pool ID:",null,"PP001",null,"Pay Band:",4,null,null,null,null,"Payout Effective Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-10"]
[null,null,"Discuss evaluation with employee and obtain signature confirming discussion.  Signature of employee does not constitute agreement with appraisal or related compensation."]
[null,null,null,{"$f":"CONCATENATE(PRA,\", Performance Review Authority\")","v":", Performance Review Authority"},null,null,null,null,null,null,{"$f":"CertifiedDate","v":"00:00:00"}]
[null,null,null,{"$f":"IF(AQ2=\"\",\"\",CONCATENATE(PPM,\", Pay Pool Manager\"))","v":""},null,null,null,null,null,null,"Date"]
[null,null,null,{"$f":"CONCATENATE(PPM,\", Pay Pool Manager\")","v":", Pay Pool Manager"},null,null,null,null,null,null,{"$f":"CertifiedDate","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,null,null,"Bob Jones",null,null,null,null,null,null,"Date"]
[null,null,null,{"$f":"IF(AS4=\"\",\"\",AS4)","v":""}]
[null,null,null,"Employee Signature",null,null,null,null,null,null,"Date"]
[null,null,"Your Perfomance Appraisal Details"]
[null,null,null,null,"Mean Objective Rating",5,null,null,null,"Evaluation of Record",{"$f":"CONCATENATE($P17,\" - \",$P18)","v":"5 - Outstanding"},null,null,null,null,5]
[null,null,null,null,"Mean Element Rating",4.67,null,null,null,null,null,null,null,null,null,"Outstanding"]
[]
[null,null,"Remarks",null,null,null,null,null,"Compensation Detail"]
[]
[null,null,null,null,null,null,null,null,null,103121,"Current Rate of Base Pay"]
[null,null,null,null,null,null,null,null,"+",1032,"DCIPS Floor Increase",null,{"$f":"Floor_GPI_Funding","v":0.01}]
[null,null,null,null,null,null,null,null,"+",4460,"Performance Pay Increase",null,4.3299999999999998E-2]
[null,null,null,null,null,null,null,null,"=",{"$f":"SUM(J22:J24)","v":108613},"New Rate of Base Pay",null,"WA"]
[null,null,null,null,null,null,null,null,"+",{"$f":"J25*M26","v":26306.068599999999},"Local Mkt Supplement","@",{"$f":"p_LocRate/100","v":0.2422},null,null,24.22]
[null,null,null,null,null,null,null,null,"=",{"$f":"MIN(J25+J26)","v":134919.0686},"New Total Base Pay"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($DM$4=\"\",$DM$4=0),\"\",CONCATENATE(\"(of which \",DOLLAR($DM$4,0),\" is Rollover from CRI)\"))","v":""}]
[null,null,null,null,null,null,null,null,null,5479,"Bonus"]
[]
[null,{"$f":"IF($AT$4=\"\",\"\",$AT$4)","v":""},"Employee Position in Pay Band"]
[null,null,"The chart plots your new salary after the applicable floor increase and performance pay increase displayed in the"]
[null,null,"Compensation Detail section. The chart depicts base pay only before the additional Local Market Supplement."]
[]
[null,null,null,null,null,null,null,null,null,null,"Your Base Pay"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Pay Band \" & H5","v":"Pay Band 4"},null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,"Band Maximum",null,{"$f":"VLOOKUP(H5,Control_Points_New,4,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,"Band Midpoint",null,{"$f":"VLOOKUP(H5,Control_Points_New,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,"Your New Base Pay",null,{"$f":"J25","v":108613}]
[null,null,null,null,null,null,null,null,null,null,"Band Minimum",null,{"$f":"VLOOKUP(H5, Control_Points_New,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,"Position in Pay Band",null,{"$f":"(CopyValue_09-CopyValue_10)/(CopyValue_07-CopyValue_10)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Your Pay Pool Results"]
[null,null,null,null,null,null,null,null,null,"Mean Overall Rating",null,null,{"$f":"ROUND(OverAllAvgRating,2)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Mean Performance Increase",null,null,{"$f":"AvgSalInc","v":""}]
[null,null,null,null,null,null,null,null,null,"Mean Bonus Amount",null,null,{"$f":"AvgBonus","v":""}]
[]
[]
[null,"*","Salaries and payout amounts are estimates and may change due to salary adjustments made after the pay pool cycle closeout date."]
[null,null,"Actual increases and bonuses are effective 10 January 2016 and will appear in your paycheck later in January."]

{"sheet":"Hidden Employee Bonus Notices","index":19,"n_rows":398,"n_cols":23,"rows_kept":398,"cut":false,"hidden":true,"merged":[[6,2,6,13],[34,6,34,9],[18,2,31,6],[5,11,5,12]]}
[null,"Employee Performance Pay Feedback (estimate*)"]
[]
[null,null,"Name:",null,"Erwin Schrodinger",null,"Work Role:",null,"Intelligence Operations Specialist",null,null,null,"Appraisal Period:"]
[null,null,"Organization:",null,"OFA/AAA",null,"Work Category:",null,"Professional",null,null,null,"1-Oct-15 to 30-Sep-16"]
[null,null,"Pay Pool ID:",null,"PP005",null,"Grade:",null,4,null,null,null,"Payout Effective Date:"]
[null,null,null,null,null,null,null,null,null,null,null,"2017-01-08"]
[null,null,"Discuss evaluation with employee and obtain signature confirming discussion.  Signature of employee does not constitute agreement with appraisal or related compensation."]
[null,null,null,{"$f":"CONCATENATE(PRA,\", Pay Pool PRA\")","v":", Pay Pool PRA"},null,null,null,null,null,null,{"$f":"CertifiedDate","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,{"$f":"CONCATENATE(PPM,\", Pay Pool Manager\")","v":", Pay Pool Manager"},null,null,null,null,null,null,{"$f":"CertifiedDate","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,null,null,{"$f":"CONCATENATE(+P13,\", Rating Official\")","v":"Hank Greenberg, Rating Official"},null,null,null,null,null,null,"Date",null,null,null,null,"Hank Greenberg","Rating Official"]
[]
[null,null,null,"Employee Signature",null,null,null,null,null,null,"Date"]
[null,null,"Your Evaluation of Record",null,null,null,null,null,null,null,{"$f":"CONCATENATE(TEXT($P16,\"#\"),\" - \",$Q$16)","v":"4 - Excellent"},null,null,null,null,4,"Excellent"]
[]
[null,null,"Remarks",null,null,null,null,null,null,"Performance-Based Payout Detail"]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(LEN(p_TotBonDol)=0,p_TotBonDol=0),\"0\",p_TotBonDol)","v":1301},"Bonus",null,null,null,null,1301]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(LEN(p_QSI)=0,p_QSI=0),\"\",p_QSI)","v":""},{"$f":"IF(p_QSIFlag=2,\"Sustained Quality Increase\",IF(p_QSIFlag=1,\"DCIPS Quality Increase\",\"\"))","v":""},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Pay Pool Results",null,null,null,null,null,null,null,null,{"$f":"EOR_Mode","v":""},{"$f":"IF(LEN($P35)=0,\"\",IF(P35=3,\"Successful\",IF(P35=4,\"Excellent\",IF(P35=5,\"Outstanding\",IF(P35=2,\"Min Successful\",IF(P35=1,\"Unacceptable\",\"No Rating\"))))))","v":""}]
[null,null,null,null,null,null,null,"Modal Evaluation Of Record",null,{"$f":"P36","v":""},null,null,null,null,null,{"$f":"IF(P35<>\"\", CONCATENATE(P35,\" - \", Q35),\"\")","v":""}]
[null,null,null,null,null,null,null,"Mean Bonus Amount","**",{"$f":"AvgBonus","v":""}]
[null,null,null,null,null,null,null,"% Receiving Bonus",null,{"$f":"Export_21","v":0}]
[]
[null,"*",null,"DCIPS Quality Increase amount is an estimate and may change due to salary adjustments made after the end of the"]
[null,null,null,"performance appraisal cycle.  Actual increases and bonuses are effective 8 January 2017 and will appear in your paycheck"]
[null,null,null," for the first pay period in January."]
[null,"**",null,"Mean Bonus Amount among employees who received a bonus."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CopyValue_25","='Employee Bonus Notices'!$A$1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U45","v":2},"Print_Area","='Employee Bonus Notices'!$A$1:$N$42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+U46","v":3},"CopyValue_03","='Employee Bonus Notices'!$D$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"CopyValue_17","='Employee Bonus Notices'!$D$13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"CopyValue_04","='Employee Bonus Notices'!$D$8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Print_Name","='Employee Bonus Notices'!$E$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"p_Org_1","='Employee Bonus Notices'!$E$4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"p_PPID","='Employee Bonus Notices'!$E$5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"p_WorkRole","='Employee Bonus Notices'!$I$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"p_WorkCat","='Employee Bonus Notices'!$I$4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"p_PB","='Employee Bonus Notices'!$I$5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"CopyValue_07","='Employee Bonus Notices'!$J$21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"CopyValue_09","='Employee Bonus Notices'!$J$23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"CopyValue_08","='Employee Bonus Notices'!$J$231"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"CopyValue_13","='Employee Bonus Notices'!$J$36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"CopyValue_14","='Employee Bonus Notices'!$J$37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"CopyValue_15","='Employee Bonus Notices'!$J$38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"CopyValue_02","='Employee Bonus Notices'!$K$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"CopyValue_05","='Employee Bonus Notices'!$K$16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"CopyValue_01","='Employee Bonus Notices'!$K$8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"p_RatingOfficial","='Employee Bonus Notices'!$P$13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"p_Rating","='Employee Bonus Notices'!$P$16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"P_Notes_Remarks","='Employee Bonus Notices'!$P$19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"p_TotBonDol","='Employee Bonus Notices'!$P$21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"p_QSI","='Employee Bonus Notices'!$P$23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"p_ROR","='Employee Bonus Notices'!$Q$16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"opt_Factor_Scores","='Employee Notices'!$B$59:$N$59"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"PrintRem_1","='Employee Notices'!$C$21:$G$31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"SpecialSC","='Hidden Config'!$A$15:$A$31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"CopyFormulaCount","='Hidden Config'!$C$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"PasteFormulaCount","='Hidden Config'!$D$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"BeginRow","='Hidden Config'!$G$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EndRow","='Hidden Config'!$H$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HiddenPersCount","='Hidden Config'!$I$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HiddenCount","='Hidden Config'!$J$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LowRating","='Hidden Sal Inc Rates'!$B$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RatingIncr","='Hidden Sal Inc Rates'!$B$5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PayoutIncrement","='Hidden Sal Inc Rates'!$B$7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonusShareLookup","='Hidden Sal Inc Rates'!$F$13:$H$37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonusShareValue","='Hidden Sal Inc Rates'!$G$5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_16","='Hidden Sal Inc Rates'!$G$5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FinalBonusShareValue","='Hidden Sal Inc Rates'!$J$5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Certified","=Instructions!$B$49"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CertifiedDate","=Instructions!$B$50"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OriginalPPM","=Instructions!$B$51"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPM","=Instructions!$B$52"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OriginalPRA","=Instructions!$B$53"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRA","=Instructions!$B$54"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cycle","=Instructions!$B$55"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPID","=Instructions!$B$56"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_43","=Instructions!$E$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version","=Instructions!$E$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CertifyInfo","=Instructions!$H$13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes_sortHeaders","=Notes!$A$3:$G$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopyNotesFormats","=Notes!$A$4:$G$4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes_sortArea","=Notes!$A$4:$H$82"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertHere_Notes","=Notes!$A$82"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NotesID","=Notes!$C$4:$C$82"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PasteNotesFormulas","=Notes!$D$4:$E$4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopyNotesFormulas","=Notes!$D$82:$E$82"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FB_Notes","=Notes!$G$4:$G$82"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes_HideArea","=Notes!$H$4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PermHide_Notes","=Notes!$H$4:$H$82"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CurrentPayTable","='Pay Bands'!$A$7:$F$37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocTable","='Pay Bands'!$B$27:$F$169"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocRates","='Pay Bands'!$B$28:$F$168"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control_Points_Current","='Pay Bands'!$B$4:$E$23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CurrentPayBands","='Pay Bands'!$B$4:$E$23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LockLocRates","='Pay Bands'!$C$28:$C$63"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control_Points_New","='Pay Bands'!$G$4:$K$23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min_RR","='Pay Bands'!$L$4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GPI","='Pay Bands'!$M$4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXIVCap","='Pay Bands'!$N$4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OldEXIVCap","='Pay Bands'!$O$4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OldGSTable","='Pay Bands'!$P$3:$T$17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NewGSTable","='Pay Bands'!$V$3:$Z$17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ValidateFlag_01","='Pay Pool Panel'!$A$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay_Pool_Panel_sortHeaders","='Pay Pool Panel'!$A$11:$EL$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ColHeaders","='Pay Pool Panel'!$A$11:$EP$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Database","='Pay Pool Panel'!$A$11:$FB$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aLastName","='Pay Pool Panel'!$A$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DatatoExport","='Pay Pool Panel'!$A$12:$AC$90,'Pay Pool Panel'!$AE$12:$AL$90,'Pay Pool Panel'!$AN$12:$BL$90,'Pay Pool Panel'!$BY$12:$DB$90,'Pay Pool Panel'!$DJ$12:$DV$90,'Pay Pool Panel'!$DX$12:$EP$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopyFormatsFrom","='Pay Pool Panel'!$A$12:$FB$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay_Pool_Panel_sortArea","='Pay Pool Panel'!$A$12:$FB$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PayPoolData","='Pay Pool Panel'!$A$12:$FB$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertHere","='Pay Pool Panel'!$A$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FormulaRow","='Pay Pool Panel'!$A$90:$FB$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YesNo","='Pay Pool Panel'!$A$93:$A$94"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HiddenRows","='Pay Pool Panel'!$A$93:$A$96"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","='Pay Pool Panel'!$A$94"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SumOfEOR","='Pay Pool Panel'!$A$95"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SumOfEORLast","='Pay Pool Panel'!$A$96"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay_Pool_Panel_HideArea","='Pay Pool Panel'!$AD$12:$AD$12,'Pay Pool Panel'!$AR$12:$AS$12,'Pay Pool Panel'!$BM$12:$BW$12,'Pay Pool Panel'!$DA$12:$DA$12,'Pay Pool Panel'!$DM$12:$DO$12,'Pay Pool Panel'!$EO$12:$FB$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBasePay","='Pay Pool Panel'!$AE$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsCol_3","='Pay Pool Panel'!$AF$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aWorkCat","='Pay Pool Panel'!$AG$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WorkCategory","='Pay Pool Panel'!$AG$12:$AG$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aWorkRole","='Pay Pool Panel'!$AI$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aWorkLoc","='Pay Pool Panel'!$AJ$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WorkLoc","='Pay Pool Panel'!$AJ$12:$AJ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aLocCode","='Pay Pool Panel'!$AL$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aRatingOfficial","='Pay Pool Panel'!$AP$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RatingOfficial","='Pay Pool Panel'!$AP$12:$AP$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReviewingOfficial","='Pay Pool Panel'!$AQ$12:$AQ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aPPM","='Pay Pool Panel'!$AR$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HiddenColumns","='Pay Pool Panel'!$AR$12:$AS$12,'Pay Pool Panel'!$DM$12:$DO$12,'Pay Pool Panel'!$EO$12:$FB$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aPRA","='Pay Pool Panel'!$AS$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aWildcard","='Pay Pool Panel'!$AT$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wc1","='Pay Pool Panel'!$AT$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_1","='Pay Pool Panel'!$AT$12:$AT$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsCol_4","='Pay Pool Panel'!$AU$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ratings","='Pay Pool Panel'!$AU$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aObjRating","='Pay Pool Panel'!$AV$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ObjRating","='Pay Pool Panel'!$AV$12:$AV$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InvalidFlags","='Pay Pool Panel'!$AV$8:$AY$8,'Pay Pool Panel'!$CK$8:$CL$8,'Pay Pool Panel'!$EB$8:$EC$8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aEleRating","='Pay Pool Panel'!$AW$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ElementRating","='Pay Pool Panel'!$AW$12:$AW$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OverAllAvgRating","='Pay Pool Panel'!$AX$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aAvgRating","='Pay Pool Panel'!$AX$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AverageRating","='Pay Pool Panel'!$AX$12:$AX$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EOR_Mode","='Pay Pool Panel'!$AY$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aRating","='Pay Pool Panel'!$AY$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rating","='Pay Pool Panel'!$AY$12:$AY$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsCol_5","='Pay Pool Panel'!$AZ$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aROR","='Pay Pool Panel'!$AZ$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aFirstName","='Pay Pool Panel'!$B$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EmpCount","='Pay Pool Panel'!$B$8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ViewSet1","='Pay Pool Panel'!$B$93"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ViewSet2","='Pay Pool Panel'!$B$94"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ViewSet3","='Pay Pool Panel'!$B$95"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UseOtherIncreases","='Pay Pool Panel'!$B$96"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wc2","='Pay Pool Panel'!$BA$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_2","='Pay Pool Panel'!$BA$12:$BA$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsCol_6","='Pay Pool Panel'!$BB$11:$BH$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"salinc","='Pay Pool Panel'!$BB$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floor","='Pay Pool Panel'!$BE$12:$BE$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BandMidpoints","='Pay Pool Panel'!$BH$12:$BH$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aCtrlPoint","='Pay Pool Panel'!$BI$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LockForNoSalInc","='Pay Pool Panel'!$BI$12,'Pay Pool Panel'!$CJ$12,'Pay Pool Panel'!$CK$12,'Pay Pool Panel'!$CL$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VCP","='Pay Pool Panel'!$BI$12:$BI$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsCol_7","='Pay Pool Panel'!$BJ$11:$DO$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CompaRatio","='Pay Pool Panel'!$BK$12:$BK$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PristineInterimShares","='Pay Pool Panel'!$BM$12:$BM$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DatatoExport2","='Pay Pool Panel'!$BM$12:$BM$90,'Pay Pool Panel'!$BT$12:$BT$90,'Pay Pool Panel'!$BV$12:$BW$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PristineSalaryShareValue","='Pay Pool Panel'!$BM$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PristineFinalShares","='Pay Pool Panel'!$BS$12:$BS$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PristineFinalCalcShareValue","='Pay Pool Panel'!$BS$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PristineBonusShareValue","='Pay Pool Panel'!$BV$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PristineBonusSharesFinal","='Pay Pool Panel'!$BV$12:$BV$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InterimShares","='Pay Pool Panel'!$BX$12:$BX$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_08","='Pay Pool Panel'!$BX$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalaryShareValue","='Pay Pool Panel'!$BX$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aSharesProration","='Pay Pool Panel'!$BY$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalShareProPct","='Pay Pool Panel'!$BY$12:$BY$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ProShares","='Pay Pool Panel'!$BZ$12:$BZ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aEmpID","='Pay Pool Panel'!$C$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EmployeeID","='Pay Pool Panel'!$C$12:$C$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HideCols","='Pay Pool Panel'!$C$92:$EL$92"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UDV1HideCols","='Pay Pool Panel'!$C$93:$EL$93"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UDV2HideCols","='Pay Pool Panel'!$C$94:$EL$94"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UDV3HideCols","='Pay Pool Panel'!$C$95:$EL$95"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TargetRow","='Pay Pool Panel'!$C$96"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FinalShares","='Pay Pool Panel'!$CG$12:$CG$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_09","='Pay Pool Panel'!$CG$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FinalCalcShareValue","='Pay Pool Panel'!$CG$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aInitSalInc","='Pay Pool Panel'!$CH$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBPOver","='Pay Pool Panel'!$CJ$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalIncOverride","='Pay Pool Panel'!$CJ$12:$CJ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalAdjust","='Pay Pool Panel'!$CK$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBPAdjust","='Pay Pool Panel'!$CK$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalIncAdj","='Pay Pool Panel'!$CK$12:$CK$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalAdjPot","='Pay Pool Panel'!$CL$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aPerfAdjJust","='Pay Pool Panel'!$CL$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PerfAdjJust","='Pay Pool Panel'!$CL$12:$CL$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_3","='Pay Pool Panel'!$CM$12:$CM$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_4","='Pay Pool Panel'!$CN$12:$CN$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aMaxInc","='Pay Pool Panel'!$CO$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aFloor","='Pay Pool Panel'!$CQ$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aFloorPct","='Pay Pool Panel'!$CV$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_06","='Pay Pool Panel'!$CV$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_18","='Pay Pool Panel'!$CV$5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_19","='Pay Pool Panel'!$CV$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RemSalFund","='Pay Pool Panel'!$CV$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aChart_01","='Pay Pool Panel'!$CW$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aPerfSalIncDol","='Pay Pool Panel'!$CW$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart_01","='Pay Pool Panel'!$CW$12:$CW$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FinalSalIncDoll","='Pay Pool Panel'!$CW$12:$CW$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_28","='Pay Pool Panel'!$CW$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aChart_02","='Pay Pool Panel'!$CX$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aPerfSalIncPer","='Pay Pool Panel'!$CX$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart_02","='Pay Pool Panel'!$CX$12:$CX$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FinalSalIncPer","='Pay Pool Panel'!$CX$12:$CX$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aChart_03","='Pay Pool Panel'!$CY$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aFinalBPIncDol","='Pay Pool Panel'!$CY$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart_03","='Pay Pool Panel'!$CY$12:$CY$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TotalSalIncDol","='Pay Pool Panel'!$CY$12:$CY$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aChart_04","='Pay Pool Panel'!$CZ$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aFinalBPIncPer","='Pay Pool Panel'!$CZ$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart_04","='Pay Pool Panel'!$CZ$12:$CZ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TotalSalIncPer","='Pay Pool Panel'!$CZ$12:$CZ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TargetColumn","='Pay Pool Panel'!$D$96"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nonNGA_HideArea","='Pay Pool Panel'!$DC$12:$DH$12,'Pay Pool Panel'!$DJ$12:$DL$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aNewIncPay","='Pay Pool Panel'!$DI$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aLocRate","='Pay Pool Panel'!$DJ$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_5","='Pay Pool Panel'!$DP$12:$DP$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_6","='Pay Pool Panel'!$DQ$12:$DQ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bonus","='Pay Pool Panel'!$DR$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsCol_8","='Pay Pool Panel'!$DR255"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsCol_9","='Pay Pool Panel'!$DV$11:$EF$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_36","='Pay Pool Panel'!$DW$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_20","='Pay Pool Panel'!$DW$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonusThreshold","='Pay Pool Panel'!$DW$7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_25","='Pay Pool Panel'!$DW$7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBonusSharesProration","='Pay Pool Panel'!$DX$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonShareProPct","='Pay Pool Panel'!$DX$12:$DX$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_21","='Pay Pool Panel'!$DX$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonusSharesFinal","='Pay Pool Panel'!$DY$12:$DY$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FinalShareCount","='Pay Pool Panel'!$DY$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBonInit","='Pay Pool Panel'!$DZ$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InitialBonus","='Pay Pool Panel'!$DZ$12:$DZ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aPPID","='Pay Pool Panel'!$E$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBonOver","='Pay Pool Panel'!$EA$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonusOverride","='Pay Pool Panel'!$EA$12:$EA$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LockForNoBonus","='Pay Pool Panel'!$EA$12:$EC$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonAdjust","='Pay Pool Panel'!$EB$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBonAdj","='Pay Pool Panel'!$EB$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonAdj","='Pay Pool Panel'!$EB$12:$EB$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonAdjPot","='Pay Pool Panel'!$EC$10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBonAdjJust","='Pay Pool Panel'!$EC$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonAdjJust","='Pay Pool Panel'!$EC$12:$EC$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aChart_05","='Pay Pool Panel'!$ED$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aTotBonDol","='Pay Pool Panel'!$ED$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart_05","='Pay Pool Panel'!$ED$12:$ED$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FinalBonus","='Pay Pool Panel'!$ED$12:$ED$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TotalBonus","='Pay Pool Panel'!$ED$12:$ED$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_14","='Pay Pool Panel'!$ED$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_22","='Pay Pool Panel'!$ED$5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Export_23","='Pay Pool Panel'!$ED$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RemainingBonus","='Pay Pool Panel'!$ED$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aChart_07","='Pay Pool Panel'!$EE$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aTotBonMP","='Pay Pool Panel'!$EE$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart_07","='Pay Pool Panel'!$EE$12:$EE$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TotalBonusPer","='Pay Pool Panel'!$EE$12:$EE$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aChart_06","='Pay Pool Panel'!$EF$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aTotBonPer","='Pay Pool Panel'!$EF$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chart_06","='Pay Pool Panel'!$EF$12:$EF$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TotalBonusPerBP","='Pay Pool Panel'!$EF$12:$EF$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QSIFlag","='Pay Pool Panel'!$EG$12:$EG$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aQSI","='Pay Pool Panel'!$EH$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QSI","='Pay Pool Panel'!$EH$12:$EH$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_7","='Pay Pool Panel'!$EI$12:$EI$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_8","='Pay Pool Panel'!$EJ$12:$EJ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_9","='Pay Pool Panel'!$EK$12:$EK$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wildcard_10","='Pay Pool Panel'!$EL$12:$EL$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes_WorkingNotes","='Pay Pool Panel'!$EM$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes_Remarks","='Pay Pool Panel'!$EN$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aFinalBand","='Pay Pool Panel'!$EY$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UseInAnalysis","='Pay Pool Panel'!$EZ$12:$EZ$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsCol_1","='Pay Pool Panel'!$F$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aSSC","='Pay Pool Panel'!$F$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSC","='Pay Pool Panel'!$F$12:$F$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aPermHide","='Pay Pool Panel'!$FA$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PermHide_Pay_Pool_Panel","='Pay Pool Panel'!$FA$12:$FA$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsCol_2","='Pay Pool Panel'!$G$11:$J$11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aIncSalary","='Pay Pool Panel'!$G$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IncInSalFund","='Pay Pool Panel'!$G$12:$G$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YesNoCols","='Pay Pool Panel'!$G$12:$J$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aIncBonus","='Pay Pool Panel'!$H$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IncInBonFunds","='Pay Pool Panel'!$H$12:$H$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aSalIncEligible","='Pay Pool Panel'!$I$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalIncEligible","='Pay Pool Panel'!$I$12:$I$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBonEligible","='Pay Pool Panel'!$J$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BonusEligible","='Pay Pool Panel'!$J$12:$J$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aOrg_1","='Pay Pool Panel'!$K$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OrgID_01","='Pay Pool Panel'!$K$12:$K$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OrgID_02","='Pay Pool Panel'!$L$12:$L$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aRetainedPay","='Pay Pool Panel'!$T$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aPB","='Pay Pool Panel'!$V$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PayBand","='Pay Pool Panel'!$V$12:$V$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aBasePayEP","='Pay Pool Panel'!$W$12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BasePay","='Pay Pool Panel'!$W$12:$W$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AdjSalary","='Pay Pool Panel'!$Y$12:$Y$90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PTUP","='Rating Charts'!$L$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertPB","='Rating Statistics'!$B$15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Org1Data","='Rating Statistics'!$B$17:$B$21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertOrg1","='Rating Statistics'!$B$21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Org2Data","='Rating Statistics'!$B$23:$B$27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertOrg2","='Rating Statistics'!$B$27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ReviewingOfficialData","='Rating Statistics'!$B$29:$B$32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertROData2","='Rating Statistics'!$B$32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RatingOfficialData","='Rating Statistics'!$B$34:$B$38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertROData","='Rating Statistics'!$B$38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WorkCatData","='Rating Statistics'!$B$40:$B$44"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertWorkCat","='Rating Statistics'!$B$44"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WildCardLabel01","='Rating Statistics'!$B$45"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WC01Data","='Rating Statistics'!$B$46:$B$47"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertWC01","='Rating Statistics'!$B$47"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PBData","='Rating Statistics'!$B$9:$B$15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SummaryFormulasPB","='Rating Statistics'!$C$15:$H$15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SummaryFormulasOrg1","='Rating Statistics'!$C$21:$H$21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SummaryFormulasOrg2","='Rating Statistics'!$C$27:$H$27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SummaryFormulasRO2","='Rating Statistics'!$C$32:$H$32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SummaryFormulasRO","='Rating Statistics'!$C$38:$H$38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SummaryFormulasWorkCat","='Rating Statistics'!$C$44:$H$44"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SummaryFormulasWC_01","='Rating Statistics'!$C$47:$H$47"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ChartAverageIncrease","='Salary Increase Charts'!$C$60:$D$61"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ChartPercentAverageIncrease","='Salary Increase Charts'!$M$60:$N$61"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertSalStat_06","='Salary Increase Statistics'!$B$14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalStatData_03","='Salary Increase Statistics'!$B$16:$B$20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertSalStat_03","='Salary Increase Statistics'!$B$20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalStatData_04","='Salary Increase Statistics'!$B$22:$B$26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertSalStat_04","='Salary Increase Statistics'!$B$26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalStatData_02","='Salary Increase Statistics'!$B$28:$B$31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertSalStat_02","='Salary Increase Statistics'!$B$31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalStatData_01","='Salary Increase Statistics'!$B$33:$B$37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertSalStat_01","='Salary Increase Statistics'!$B$37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalStatData_05","='Salary Increase Statistics'!$B$39:$B$43"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertSalStat_05","='Salary Increase Statistics'!$B$43"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WildCardLabel02","='Salary Increase Statistics'!$B$44"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WC02Data","='Salary Increase Statistics'!$B$45:$B$46"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertWC02","='Salary Increase Statistics'!$B$46"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SalStatData_06","='Salary Increase Statistics'!$B$8:$B$14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopySalStat_06","='Salary Increase Statistics'!$C$14:$L$14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopySalStat_03","='Salary Increase Statistics'!$C$20:$L$20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopySalStat_04","='Salary Increase Statistics'!$C$26:$L$26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopySalStat_02","='Salary Increase Statistics'!$C$31:$L$31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopySalStat_01","='Salary Increase Statistics'!$C$37:$L$37"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopySalStat_05","='Salary Increase Statistics'!$C$43:$L$43"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SummaryFormulasWC_02","='Salary Increase Statistics'!$C$46:$L$46"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO_SalDol_Overall","='Salary Increase Statistics'!$F$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO_SalDol_PayBand","='Salary Increase Statistics'!$F$8:$F$14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AvgSalInc","='Salary Increase Statistics'!$G$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO_SalPct_Overall","='Salary Increase Statistics'!$G$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO_SalPct_PayBand","='Salary Increase Statistics'!$G$8:$G$14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO_TotDol_Overall","='Salary Increase Statistics'!$H$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO_TotDol_PayBand","='Salary Increase Statistics'!$H$8:$H$14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO_TotPct_Overall","='Salary Increase Statistics'!$I$6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO_TotPct_PayBand","='Salary Increase Statistics'!$I$8:$I$14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary_sortHeaders","=Summary!$A$2:$R$2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopySummaryFormats","=Summary!$A$3:$T$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary_Data","=Summary!$A$3:$T$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary_sortArea","=Summary!$A$3:$T$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InsertSummaryData","=Summary!$A$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SummaryID","=Summary!$C$3:$C$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PasteSummaryForm_01","=Summary!$D$3:$D$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopySummaryForm_01","=Summary!$D$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PasteSummaryForm_02","=Summary!$F$3:$R$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PasteFormulas","=Summary!$F$4:$G$80,Summary!$I$4:$T$80"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopyFormulas","=Summary!$F$81:$G$81,Summary!$I$81:$T$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CopySummaryForm_02","=Summary!$F$81:$R$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary_HideArea","=Summary!$T$3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PermHide_Summary","=Summary!$T$3:$T$81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ChartPercentTotalAverageIncrease","='Total Salary Increase Charts'!$C$57:$D$58"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ChartTotalAverageIncrease","='Total Salary Increase Charts'!$M$57:$N$58"]